You're welcome!

Just be aware that you need to poll those values into a table & query the delta between samples, as SQL Server continually increments the counters throughout the...

IO problems can definitely occur without disk queuing. This is easy to understand when you take into consideration the fact that SQL Server has an internal workload scheduling component -...

fn_virtualfilestats() is definitely the tool for this job.

Here's a script I wrote last year which makes using this TSQL system function easy..

http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/2006/03/15/59.aspx

Hi John

SQL Server 2000 Standard Edition has a hard wired memory limit of 2Gb, whether it's running under an x64 or x86 O/S. SQL 2000 Enterprise Edition does not have...

Some corrections to this thread:

(a) AWE is indeed dynamic under SQL 2005 (it wasn't under SQL 2000)

(b) It's not true to say that Taskman is inaccurate for AWE - it...

Thanks for posting this Steve & also for the discussion everyone.

I have re-opened the connect suggestion because I believe MS missed something significant in their response. Their recent response claims...