Using @@Total_Read and @@Total_Write

Ever wondered how many physical reads and writes your SQL service is doing? Yes, it may seek a bit geeky, but it's often useful to have an idea if a server is read or write heavy. @@Total_Read and @@Total_Write show you the number of physical (not logical) reads since the last service restart, and from there we can easily calculate a percentage of reads if needed.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Vinod on 3/4/2010

The query is not fully visible

Jonathon Moorman on 3/4/2010

I didn't eralize that these variables existed! Thanks Andy. I agree -- they're quite good for curiosity.

R Michael Lacy on 3/4/2010

Nice job! Thanks for the demo scripts, too.

Arun on 3/4/2010

Thanks Andy. Nice Info.

Arun on 3/4/2010

Thanks Andy. Nice Info.

Leonard Peoples on 3/4/2010

It may come in handy

punjwani on 3/4/2010

This is good information, like to hear more from you.

Joshua Clausen on 3/4/2010

good overview

Jim Buttery on 3/4/2010

I would really like to extend this to find out what I/O impact there is as different business units come on line. This could be triggered or run hourly.Thanks for the vid.

Kevin on 3/4/2010

Excellent information, as always. Thanks.

Mahesh Jakhmola on 3/5/2010

can not see the entire query.

Andre on 3/6/2010

Thanks