bigator

Archive for the ‘Dynamic Management Views’ Category

What ?? There is a “Ghost” in SQL Server !!!

Yes, it’s a cleanup process available as a part of SQL Server Storage Engine. It runs in background to cleanup ghost records. If you can remember … “When we create a clustered index then it stores actual data/records at the leaf level of the index.” And SQL Server marks/declares a record as a ghost records […]

bigatorMarch 23, 2012 · bigatorKhilitchandra Prajapati · bigatorOne Comment
bigatorTags: , , ,  · Posted in: DMX, Dynamic Management Views, SQL Server

A Set of Boon Tools – SSAS DMVs in SQL Server 2012

Hi All, As you must have heard or started using DMVs (Dynamic Management View) available in SQL Server to get information about local server operations and server health. But today I would like to focus specially on DMVs for monitoring SSAS (SQL Server Analysis Services) and dig-down to find out how powerful it can be. […]

bigatorMarch 1, 2012 · bigatorKhilitchandra Prajapati · bigatorOne Comment
bigatorTags: , ,  · Posted in: DMX, Dynamic Management Views, Quick Tips, SQL Server, Uncategorized


bigator