Today on SQLShare

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.

Duration: 1 mins 33 secs

Random Videos From the Archives

Related Videos

• Using Transactions in SSIS by Brian Knight
• Saving a Query Plan by Grant Fritchey
• Connecting to a SQL Compact Database by Mike Wells
• The Default Trace in SQL Server 2005 by Brian Kelley
• Monitoring Exec Cache in SQL Server - Part 1 by Jon Kehayias

• Working with Foreign Keys by Andy Warren
• More on Instead of Triggers by Andy Warren
• Removing a File From a Filegroup by Andy Warren
• Understanding DBCC Show_Statistics by Andy Warren
• Using a UDL File for Database Connectivity Testing by Andy Warren