Snipplr http://snipplr.com/language/sql/tags/DMV Recent snippets posted on Snipplr.com en-us Sun, 19 May 2013 16:58:20 GMT (SQL) List of current sessions causing blocking - tvanzele http://snipplr.com/view/34605/list-of-current-sessions-causing-blocking/

]]> Mon, 17 May 2010 01:56:20 GMT http://snipplr.com/view/34605/list-of-current-sessions-causing-blocking/ (SQL) list of current locks - tvanzele http://snipplr.com/view/34604/list-of-current-locks/

]]> Mon, 17 May 2010 01:52:18 GMT http://snipplr.com/view/34604/list-of-current-locks/ (SQL) Get current users and connection type - tvanzele http://snipplr.com/view/34198/get-current-users-and-connection-type/

]]> Tue, 11 May 2010 08:21:35 GMT http://snipplr.com/view/34198/get-current-users-and-connection-type/ (SQL) Collection of I/O specific DMV's - tvanzele http://snipplr.com/view/34122/collection-of-io-specific-dmvs/ http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!2991.entry

]]> Mon, 10 May 2010 08:02:12 GMT http://snipplr.com/view/34122/collection-of-io-specific-dmvs/ (SQL) Index Read/Write/Fill Factor stats (current DB) - tvanzele http://snipplr.com/view/32186/index-readwritefill-factor-stats-current-db/

]]> Sat, 17 Apr 2010 08:58:33 GMT http://snipplr.com/view/32186/index-readwritefill-factor-stats-current-db/ (SQL) List of recovery model, log reuse wait description, log file size, log usage size and compatibility level for all databases on i - tvanzele http://snipplr.com/view/32110/list-of-recovery-model-log-reuse-wait-description-log-file-size-log-usage-size-and-compatibility-level-for-all-databases-on-i/

]]> Fri, 16 Apr 2010 04:08:09 GMT http://snipplr.com/view/32110/list-of-recovery-model-log-reuse-wait-description-log-file-size-log-usage-size-and-compatibility-level-for-all-databases-on-i/ (SQL) List of single-use, ad-hoc queries that are bloating the plan cache - tvanzele http://snipplr.com/view/32109/list-of-singleuse-adhoc-queries-that-are-bloating-the-plan-cache/

]]> Fri, 16 Apr 2010 04:06:18 GMT http://snipplr.com/view/32109/list-of-singleuse-adhoc-queries-that-are-bloating-the-plan-cache/ (SQL) Display logfile size and usage via dmv - tvanzele http://snipplr.com/view/31966/display-logfile-size-and-usage-via-dmv/

]]> Thu, 15 Apr 2010 08:06:32 GMT http://snipplr.com/view/31966/display-logfile-size-and-usage-via-dmv/ (SQL) Display Missing Indexes of the Current DB ordered by Index Advantage - tvanzele http://snipplr.com/view/31396/display-missing-indexes-of-the-current-db-ordered-by-index-advantage/

]]> Mon, 12 Apr 2010 09:05:41 GMT http://snipplr.com/view/31396/display-missing-indexes-of-the-current-db-ordered-by-index-advantage/ (SQL) Page and row-count information for every partition in the current database - tvanzele http://snipplr.com/view/31382/page-and-rowcount-information-for-every-partition-in-the-current-database/

]]> Mon, 12 Apr 2010 08:24:28 GMT http://snipplr.com/view/31382/page-and-rowcount-information-for-every-partition-in-the-current-database/ (SQL) Cached SPs By Total Physical Reads (SQL 2008 only) - tvanzele http://snipplr.com/view/31363/cached-sps-by-total-physical-reads-sql-2008-only/

]]> Mon, 12 Apr 2010 03:50:53 GMT http://snipplr.com/view/31363/cached-sps-by-total-physical-reads-sql-2008-only/ (SQL) Get current users and # sessions - tvanzele http://snipplr.com/view/30790/get-current-users-and--sessions/

]]> Fri, 02 Apr 2010 04:54:56 GMT http://snipplr.com/view/30790/get-current-users-and--sessions/ (SQL) Find tables without a clustered index - tvanzele http://snipplr.com/view/30665/find-tables-without-a-clustered-index/

]]> Thu, 01 Apr 2010 01:36:11 GMT http://snipplr.com/view/30665/find-tables-without-a-clustered-index/ (SQL) Index fragmentation in all db's per instance - tvanzele http://snipplr.com/view/30631/index-fragmentation-in-all-dbs-per-instance/

]]> Wed, 31 Mar 2010 08:43:12 GMT http://snipplr.com/view/30631/index-fragmentation-in-all-dbs-per-instance/ (SQL) Who is connected via SQL DAC - tvanzele http://snipplr.com/view/30629/who-is-connected-via-sql-dac/

]]> Wed, 31 Mar 2010 08:39:36 GMT http://snipplr.com/view/30629/who-is-connected-via-sql-dac/ (SQL) Wait stat list (user sessions) - tvanzele http://snipplr.com/view/30618/wait-stat-list-user-sessions/

]]> Wed, 31 Mar 2010 06:42:31 GMT http://snipplr.com/view/30618/wait-stat-list-user-sessions/ (SQL) Percentage of IO for each database and per driveletter - tvanzele http://snipplr.com/view/30517/percentage-of-io-for-each-database-and-per-driveletter/

]]> Tue, 30 Mar 2010 06:57:03 GMT http://snipplr.com/view/30517/percentage-of-io-for-each-database-and-per-driveletter/ (SQL) Percentage of IO for each database - tvanzele http://snipplr.com/view/30516/percentage-of-io-for-each-database/

]]> Tue, 30 Mar 2010 06:44:32 GMT http://snipplr.com/view/30516/percentage-of-io-for-each-database/ (SQL) Open transactions with text and plans - tvanzele http://snipplr.com/view/30454/open-transactions-with-text-and-plans/

]]> Mon, 29 Mar 2010 02:55:01 GMT http://snipplr.com/view/30454/open-transactions-with-text-and-plans/ (SQL) Cached Query Plans per object type - tvanzele http://snipplr.com/view/30451/cached-query-plans-per-object-type/

]]> Mon, 29 Mar 2010 02:42:05 GMT http://snipplr.com/view/30451/cached-query-plans-per-object-type/