Browse by Tags

All Tags » General Tuning » operating systems (RSS)
03 April 2008 12:53

Disk Partition Alignment ( SANs and Diskpart )

As a further post to my series on what else can affect SQL Server Performance here’s the thorny issue of disk partition alignment. Disclaimer : I don’t get to configure SANs, places I work have dedicated teams and it’s unlikely a DBA would be considered...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: , , ,
26 March 2008 08:02

Configuring x64 SQL Server

I often read a number of forum posts concerning performance / configuration issues with x64 SQL Server. I've also found some interesting views on how much memory you can allocate to SQL Server on a x64 install ( I don't have any experience of...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
25 March 2008 22:11

Do you really need those services?

As a continuation of my series of posts which look at Windows Server rather than SQL Server here's one about services. o When your SQL Server is under pressure stopping or disabling unnecessary services may free up resource. o This is especially true...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
12 March 2008 19:57

Things that may not be right on your SQL server.

Ø When performance is under the spotlight most often the finger is pointed at SQL Server, here’s a short list of things that may impact your server performance. Disclaimer : This is my personal hit list and in no particular order. Out of date drivers...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: , ,
10 January 2008 12:32

Tuning SQL Server configurations

One place to sometimes view configuration for SQL Server is the full disclosure documents for TPC benchmarks, yes I know I should get out more, however, it does sometimes make for interesting reading on exactly how some fantastic throughput is achieved...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
06 January 2008 20:41

Configuring Windows 2003 ( x64 ) for SQL Server

There is an almost constant stream of posts on forums asking about configuration of SQL Server 2005 memory, especially for x64 editions. Alongside these are also a number of posts concerning performance or perceived performance issues with x64 SQL Server...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , , ,