Browse by Tags

All Tags » Diagnostics » General Tuning (RSS)
10 June 2008 20:30

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...
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 | 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: , , ,
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: , ,
22 February 2008 20:34

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...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
30 January 2008 19:18

Things I learned today

I'm involved with some tuning as usually tends to be the case and amongst the work I've been doing a couple of interesting points arose. Firstly we upgraded the memory in the production cluster, what was unusual for me was that we added more memory than...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , , ,
24 January 2008 18:58

Perfmon Counters thresholds

Just in case you missed the link to The Premier's blog http://sqlblogcasts.com/blogs/thepremiers/archive/2008/01/23/monitoring-sql-server-using-performance-monitor.aspx they've just posted details of a perfmon trace viewer. But what is more important...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
24 September 2007 13:53

An update on the TokenAndPermUserStore “problem”

http://sqlblogcasts.com/blogs/grumpyolddba/archive/2007/07/19/more-tokenandpermuserstore.aspx As the original incident had been raised on the back of an application service pack upgrade I made use of one of my msdn incidents. I have patch 3179 applied...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
19 September 2007 11:34

Are your SAN drives performing well?

Those that know me know that I consider SAN's to be one of the major bottlenecks to high performance SQL Server databases; certainly my experience over the years has often shown this to be the case - however that's a whole other area for discusion, what...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
02 August 2007 15:38

SQL 2005 Hotfixes

WesleyB kindly posted a link to allow me to see this list http://support.microsoft.com/kb/937137 http://sqlug.be/blogs/wesleyb/archive/2007/08/01/tokenandpermuserstore-continued.aspx Having been told I need a specific patch for the cache problems it seems...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
19 July 2007 11:06

More TokenAndPermUserStore

I was interested in Jasper’s post http://sqlblogcasts.com/blogs/sqldbatips/archive/2007/07/18/troubleshooting-performance-issues-with-tokenandpermuserstore-in-sql2005.aspx?CommentPosted=true#commentmessage The following may also be of interest to readers...
Posted by GrumpyOldDBA | 14 comment(s)
Filed under: ,
16 July 2007 13:47

More Tom Davidson Magic

If you ever downloaded these two SQL 2000 documents, and I can’t find the links to them any more, you’ll know how great Tom Davidson’s white paper on waits and queues is and how it is the standard reference for what all those waits that you find in sysprocesses...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: ,
04 January 2007 16:48

Not Thinking it through - the saga continues

The saga continues ……….. Here below are the previous posts which relate to the management of a production SQL Server ( by a third party ). We asked that the job which re-indexes the database be disabled until such time as the issue of the database mode...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,