Browse by Tags

Parallelism, CPU Time & DMV’s
30 May 2011 12:04

Whilst reviewing the CPU statistics of a system that i knew was CPU bound i found the numbers were not adding up and i was not seeing the code i expected to see as a top CPU consumer so i decided to going digging. I quickly identified that if the query has gone parallel it: Only shows as one thread in sys.dm_exec_requests because sys. dm_exec_requests does not... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, Tools, Tips, Performance, Database Engine, 2008, 2008 R2, SQL 2008, CPU, Parallelism, DMV

Server Side Aliases
07 November 2010 21:37

Over the years i have come across a few situations where server side connections to SQL server fail when you use a DNS alias that points back to the server your initiating the connection from but you can connect remotely. Its an annoying problem which has a very unhelpful error message that changed in different versions of SQL. In SQL 2000 you are presented with... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, SQL 2000, Tips, Database Engine, 2008

Exploring backup read io performance
24 January 2010 14:12

I was recently exploring how to increase the backup read throughput on one of our SQL servers. Below are some interesting facts i found. I would say that one of the most important reminders that came from the exercise is, do not assume that 2 databases being backup up on the same server using an identical backup command means that the processes are identical... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, Tips, Performance, Database Engine, 2008, Backup

The overhead of a non-unique clustered index
20 October 2008 00:21

So, we all know that if we create a clustered index that is not unique that we will incur a 4 byte overhead right? Well not always because as usual, it depends..... When you create a non-unique clustered index SQL server must maintain uniqueness so it adds a hidden 4 byte column which is populated for each non-unique row (not every row) but what many people may... Read More...

by ACALVETT | 9 comment(s)

Filed under: SQL 2005, SQL 2000, Tips, Database Engine

Changing the Data Files Location after Installation
10 August 2008 10:28

The other day i wanted to change the "Data Files" location for a 2005 database engine installation and a 2005 Analysis Services installation which you can specify under the advanced options during installation. I quickly found out that there appears to be no documented ways to do this other than uninstall SQL Server and install again specifying a new... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, Tips, Analysis Services, Database Engine