Welcome to Aussie SQL Server Bloggers Sign in | Join | Help

February 2006 - Posts

Saturday, 25 February 2006 9:05 AM

Measure database file i/o with fn_virtualfilestats (SQL2000 AND SQL2005)

I'm posting another admin script today which can be useed on either SQL Server 2000 or SQL Server 2005 to measure i/o behaviour against specific database files, using the fn_virtualfilestats() system TSQL function. This script is useful when you need
posted by Greg_Linwood | 0 Comments
Filed Under:
Saturday, 11 February 2006 11:20 AM

A simple SQL2000 Deadlock script

Analysing SQL Server deadlocks can be a tedious process. I'm currently working on a server that's experiencing a few & I wanted a script that could easily pull out the deadlock events from a sql error log, to save me from fishing between all of the
posted by Greg_Linwood | 1 Comments
Filed Under:
Wednesday, 1 February 2006 6:23 PM

Parallelism on OLTP often kills performance (so turn it off)...

One of my customers is currently converting to SQL Server 2005 Ent Edn 64bit & was disappointed today to observe a query which had been running well on SQL 2000 perform extremely badly on SQL 2005 in the test lab. So I asked for the 2000 / 2005 execution
posted by Greg_Linwood | 1 Comments
Filed Under: