Welcome to TechNet Blogs Sign in | Join | Help

January 2005 - Posts

Monday, January 31, 2005 3:26 PM

SQL Server Lock Escalation – Friend of Foe?

Sometimes I hear the comment that someone can’t get their application to scale above 50 – 100 users; above a certain number of users there is a sudden ceiling in scalability.   So often I have found this to be a problem with nothing more than SQL
posted by Mat_Stephen | 3 Comments
Filed Under:
Wednesday, January 26, 2005 9:31 PM

SP I promised during TechNet Gig on SQL Performance which will identify blocking spid at top of blocking chain : sp_blocker_pss80

Please follow the link below to the MS KB article containing the above SP. Note the 'fast' parameter to improve performance by reducing the amount of extra diagnostic info returned. http://support.microsoft.com/default.aspx?scid=kb;en-us;271509 Hope
posted by Mat_Stephen | (Comments Off)
Filed Under: ,
Tuesday, January 25, 2005 12:01 AM

CREATE proc track_waitstats & CREATE proc get_waitstats - useful code for diagnosing SQL 2000 performance

For those attending my TechNet SQL 2000 performance tuning session at TVP Reading on Tuesday 25th Jan, here is the code for the track_waitstats and get_waitstats stored procedures I refer to during the presentation.   CREATE proc track_waitstats
posted by Mat_Stephen | 3 Comments
Filed Under: ,
Monday, January 10, 2005 1:50 PM

Oracle RAC, Grid, IBM, and Microsoft: A Corporate Altercation or Religious Divergence

People often ask me, “When Microsoft is going to get into the type of clustering as defined by Oracle’s RAC (Real Application Clusters)?”  Generally, I find these are people who believe the technical concepts behind RAC are the way of the future,
posted by Mat_Stephen | 3 Comments
Filed Under: ,
Friday, January 07, 2005 11:23 AM

SQL Server Health and History Tool (SQLH2)

This tool has been available for a couple of months but I only found out about it yesterday; I was reading some stuff about SQL Server 2005 and found a reference to say this tool will be supported in SQL 2k5.  Realising such downloads have sometimes
posted by Mat_Stephen | (Comments Off)
Filed Under: , , ,
Wednesday, January 05, 2005 12:46 PM

Catch the SQL Server 2005 Express, it’s the future and it’s free!

We’ve all been waiting a long time for SQL Server 20005 and not everyone has been able to get the betas to get an early look.  Well now anyone can get their hands on the beta 2 of SQL Server 2005 Express edition.   The Express edition, what’s
posted by Mat_Stephen | 6 Comments
Filed Under: ,
Monday, January 03, 2005 10:28 PM

Hitchhicker’s Guide to SQL Server Reporting Services author to present at IT Forum Highlights - Birmingham UK 13th Jan 05

Hitchhiker’s Guide to SQL Server Reporting Services is an excellent book in the Hitchhiker’s series of excellent books.  The book is co written by Peter Blackburn (UK MVP) and William Vaughn (massive reputation).  I think it is excellent for
posted by Mat_Stephen | (Comments Off)
Filed Under: ,