Browse by Tags

Dates - especially when SQL Server can't be British!

Just like memory config dates never seem to go away and I've had some discussions with our BI team recently on why things were not working quite as expected, especially on the 13th of the month; and I noticed the same issue had arisen for a member of the UK SSUG - Anyway rather than spend time writing...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 06-09-2008
Information Overload ??

As I've remarked before the profusion of Blogs ( from the various Microsoft teams and individuals ) whilst exposing so much more information then we ever had before also requires you to almost spend all your time just checking every blog you can find every day, and that's assuming you actually...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 05-01-2008
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 a reference point regarding storage. What I can...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 04-03-2008
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 ia64 - sorry ). Sort of cross purposes I've been...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 03-26-2008
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 of x32 systems where bottom memory allocation...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 03-25-2008
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 Look mainly for HBA, NIC and storage controllers Incorrect...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 03-12-2008
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 in a test environment. I'm still researching x64...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 01-10-2008
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. Now I don’t claim to have all the answers but...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 01-06-2008

Page 1 of 1 (8 items)