Browse by Tags

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
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
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
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
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 we had databases, I've never worked a production...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 01-30-2008
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 is the attached documentation on perfmon counters...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 01-24-2008
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 and I can see that the cache size fluctuates over...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 09-24-2007
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 I though I'd draw attention to is a superb post...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 09-19-2007
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 maybe that info was incorrect < grin >

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 08-02-2007

Page 1 of 2 (13 items) 1 2 Next >