Browse by Tags

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 all read the entire KB before doing anything - right...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 07-19-2008
Performance Dashboard for SQL 2008

Just in case you haven't seen this http://sqlblogcasts.com/blogs/thepremiers/archive/2008/06/20/sql-server-2008-performance-studio.aspx then have a read. As I actually create dashboards and performance reporting for sql 2000 and sql 2008, and have been for many years, I'm seeing some of my work...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 06-23-2008
Tracking problem indexes in SQL 2000

It’s all so easy(ish) to work within SQL 2005 but the reality is that there are still more SQL 2000 databases than SQL 2005, so I’m told, and I’m supporting one of them right now. I’ve been contemplating on how to get a handle on which of my indexes are fragmenting too quickly and where the high levels...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 06-10-2008
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
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
Bug in UK SSUG 2008

It was discovered earlier today that SSUG 2008 was unable to distinguish a Thursday when it fell before a bank holiday friday and as a consequence SSUG would be unable to function on March 20th. It's not thought that other Thursdays that fall before a Friday bank holiday will cause similar problems,...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 03-19-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
Only once every four years thank goodness!

I never cease to be amazed by what I discover within IT, mostly these days I'm more disappointed than anything else, I'm not a lover of the let's bash Microsoft about security patches or we should all use Linux / Open source as in the latter I'm sure if the most popular o/s was linux it would be full...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 02-29-2008
dbcc dropcleanbuffers - or maybe not

As a consequence of another action I was prompted to want to clear the buffer cache – or to be more precise I tried to clear the buffer cache. So stepping back, what happens if you install more memory than the combined size of your databases? Most would probably suggest that it’s a waste of time, however...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 02-22-2008

Page 1 of 4 (34 items) 1 2 3 4 Next >