Browse by Tags

All Tags » operating systems » Diagnostics (RSS)
19 March 2009 20:39

How to determine that hardware DEP is available and configured on your computer

Well here we are again with another post I’d been saving up until I resolved the images issue. DEP and how it affects memory on your SQL Server!!! Microsoft KB: 912923    MICROSOFT KB: 875352 ===========================================...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , , , , , ,
04 March 2009 22:35

NTFS Fragmentation may be more harmful than you think

I’ve posted previously about the adverse affect of ntfs fragmentation and I’ve also mentioned that it is sometimes suggested that fragmentation is not a concern on a SAN. I’ve yet to finish testing this on a SAN, after all you don’t often get a free play...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
19 July 2008 12:08

Cannot generate SSPI context

Now here's a slightly interesting point about this error. Although the kb does actually mention this reason for the error it is about the last thing on the article, a footnote, and it doesn't specifically word it to cover this scenario, and we...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
09 June 2008 18:54

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...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
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 | 4 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: , , ,
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: , ,