This metric measures the amount of memory used in the buffer cache by the largest object (based on the number of pages). It checks the sys.dm_os_buffer_descriptors to identify the object, and returns the relative percentage used. You should use this metric if you want to monitor what is in the buffer area, or if you are having performance-related disk read problems.
2013-07-22
3,313 reads
Sometimes recovery simply entails rerunning a failed process.
2013-07-19
3,818 reads
Join Red Gate for a free a seminar on July 26 (the day before SQL Saturday Sacramento). SQL Server MVP experts, Steve Jones and Grant Fritchey will present sessions featuring best practices for SQL Server database development and deployment, in addition to showing Red Gate tools in action.
2013-07-18
1,834 reads
SQL Saturday will be in Iowa City on July 27, 2013. This free day of SQL Server Training and Networking will also have pay-for pre-conference sessions presented by Bill Pearson, Louis Davidson and Tim Mitchell.
2013-07-18
2,185 reads
SQL Saturday is coming to Sacramento on July 27, 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday also features a paid-for full day pre-con session with Kalen Delaney
2013-07-17
413 reads
Join us for a free day of SQL Server training and networking on July 27 in Cocoa Beach, Florida.
2013-07-16
2,065 reads
SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jul 13 2013 at Grantham-Allee 20, Sankt Augustin, Cologne/Bonn, Rheinland, 53757 , Germany.
2013-07-09 (first published: 2013-07-05)
311 reads
This metric returns the number of check constraints that have their is_not_trusted flag set to 1 in the sys.check_constraints table. Untrusted constraints force SQL Server to construct less efficient query plans, because it doesn’t know enough about the kind of data contained in the table. This can point to a data integrity issue which should be investigated.
2013-07-08
2,585 reads
Join us for a free day of SQL Server training and networking in Louisville Kentucky on July 13.
This SQL Saturday event also has 2 paid pre-con all day sessions on July 12 presented by Dave Fackler and Bill Pearson.
2013-07-02
2,303 reads
Download your free copy of SQL Server Transaction Log Management and see why understanding how log files work can make all the difference in a crisis.
2013-06-27
5,550 reads
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers