DotNetShoutout - Stories tagged with dmv

dmv

atom rss
3
Shouts
spam Shout it Mute it

SQL-Articles » New DMV’s in SQL Server 2011 aka Denali
posted by sqlarticlessqlarticles 630 days, 23 hours, 57 minutes ago
Wednesday, August 31, 2011 1:51:33 PM GMT
Denali CTP3 is already released and we have new DMV’s accompanied with this version which will be very useful for us. I’m going to cover the DMV that are all generic and not to a specific feature of Denali, I’ll will cover those DMV’s while writing article on that feature. There are around 8 DMV’s which I’m going to discuss it now.Below are the list of DMV’s that I’m talking about Read more: http://sql-articles.com/articles/dba/new-dmvs-in-sql-server-2011-aka-denali/#ixzz1Wc9Tw7DY (more)
category: Data | clicked: 0 | comment | | source: sql-articles.com
tags: DBA, denali, Administration, sqlarticles, dmv, SQL Server 2011
8
Shouts
spam Shout it Mute it

Identifying currently running SQL queries
published 1106 days, 4 hours, 24 minutes ago posted by sonukapoorsonukapoor 1108 days, 53 minutes ago
Thursday, May 13, 2010 9:24:37 AM GMT Tuesday, May 11, 2010 12:56:06 PM GMT
This article is taken from the book SQL Server DMVs in Action. The author discusses a routine that identifies the SQL queries that are currently running, which is useful for debugging. (more)
category: Data | clicked: 0 | comment | | source: dotnetslackers.com
tags: sp_who2, SQL, dmv
5
Shouts
spam Shout it Mute it

SQL-Articles - Capture SQL Performance Counters through TSQL
published 1140 days, 2 hours, 11 minutes ago posted by sqlarticlessqlarticles 1140 days, 17 hours, 55 minutes ago
Friday, April 09, 2010 11:37:28 AM GMT Thursday, April 08, 2010 7:54:14 PM GMT
Performance counters are useful to gather information about server status and we can analyze the server status later using these data. In my environment one of my client is not ready to pay or buy metrics tools (normally we will be using BMC, HP etc). Our windows team has written they own custom scripts to capture the counters related to them... (more)
category: Data | clicked: 0 | comment | | source: sql-articles.com
tags: counter, dmv, performance counter