SqlServerKudos - Stories tagged with DMV

DMV

atom rss
1
kudos
spam Kudos Remove

SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV
published 13 days, 5 hours, 37 minutes ago posted by sasa 22 days, 7 hours, 33 minutes ago
Sunday, July 18, 2010 2:27:34 PM GMT Friday, July 09, 2010 12:32:07 PM GMT
SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV
How many times have you taken help from SQL Server DMVs? How many of them are useful for your day-to-day data platform management? Well, they are closely attached to my day-to-day work. I'm excited to get my hands on upcoming client's project about their SQL Server platform review on the aspects of providing roadmap for the data-tier form a performance & scalability aspects with an additional flavour of high availability. In such scenarios I always keep my DBA-toolkit (scripts & references)...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: best practice, cpu, database user, DBA, DMV, Memory, server scope, SQL Server, SQL Server 2008 R2, sys.dm_os_
1
kudos
spam Kudos Remove

TSQL to get list of operations in active transaction of the current session
published 174 days, 19 hours, 44 minutes ago posted by sasa 184 days, 7 hours, 30 minutes ago
Sunday, February 07, 2010 12:21:05 AM GMT Thursday, January 28, 2010 12:35:06 PM GMT
TSQL to get list of operations in active transaction of the current session
SQL Server has a wealth of Dynamic Management Views (DMVs) to get you health status of the platform. All the data will be extracted with a query, set of transactions and many more ways, in this case you had to be careful with transactions, because whenever so much data was flowing back and forth between the application server and the database server, too many things could go wrong. Here is the quick DMV that can get you list of operations in active transaction of the current session declare @xactid...(re... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: active, DMV, new features, SQL Server, transaction, TSQL
1
kudos
spam Kudos Remove

Query to obtain every dependent object of a compiled plan when you pass a valid plan_handle in as a parameter
published 175 days, 19 hours, 45 minutes ago posted by sasa 185 days, 7 hours, 35 minutes ago
Saturday, February 06, 2010 12:20:08 AM GMT Wednesday, January 27, 2010 12:30:08 PM GMT
Query to obtain every dependent object of a compiled plan when you pass a valid plan_handle in as a parameter
Every database object will have a sort of dependency between them, such as a stored procedure to run few queries against a table. Similar to this whenever a SP or query is executed then a compiled plan will be generated by the SQL query optimizer, to note about there are two main types of plans in the Object and SQL plan cache stores: compiled plans and execution plans. For every execution context for better optimization such compiled plans are considered valuable memory objects, since they can be...(rea... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: cache, DMV, dynamic, monitor, Performance, query plan, SQL Server, tempdb, TSQL
1
kudos
spam Kudos Remove

TSQL script to obtain I/O utilization characteristics of each filegroup and the databases
published 211 days, 22 hours, 29 minutes ago posted by sasa 221 days, 10 hours, 37 minutes ago
Thursday, December 31, 2009 9:35:27 PM GMT Tuesday, December 22, 2009 9:28:10 AM GMT
TSQL script to obtain I/O utilization characteristics of each filegroup and the databases
One of the primary design goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. SQL Server builds a buffer pool in memory to hold pages read from the database. Much of the code in SQL Server is dedicated to minimizing the number of physical reads and writes between the disk and the buffer pool. On the same line if we talk about I/O, then the primary purpose of a SQL Server database is to store and retrieve data, so intensive... (more)
category: News | clicked: 0 | 1 comment | | source: sqlserver-qa.net
tags: Best Practices, configuration, disk, DMV, i/o, reads, Scheduler, SQL Server, TSQL, writes
1
kudos
spam Kudos Remove

How fast you can obtain information about missing indexes? Its easy and quick!
published 241 days, 25 minutes ago posted by sasa 250 days, 8 hours, 48 minutes ago
Wednesday, December 02, 2009 7:39:50 PM GMT Monday, November 23, 2009 11:17:23 AM GMT
How fast you can obtain information about missing indexes? Its easy and quick!
On the subject line the process to find the answer is not a short one! By design SQL Server engine takes care when the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the best indexes do not exist, the query optimizer generates a suboptimal query plan, but still stores information about these indexes. The missing indexes feature from 2008 version (in specific) enables you to access information about these indexes so you can decide...(rea... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: best practice, dbas, DMV, Execution Plan, index hint, Indexes, Monitoring, Performance, SQL Server, view server state
1
kudos
spam Kudos Remove

SQL Server Security, Performance & Tuning (SSQA.net) : SQL Server: Monitor and Manage Database Maintenance issues - DBCC, backup and spotlight on tempdb and Transaction log backup performance
published 316 days, 6 hours, 53 minutes ago posted by sasa 325 days, 21 hours, 19 minutes ago
Friday, September 18, 2009 1:12:05 PM GMT Tuesday, September 08, 2009 10:46:15 PM GMT
SQL Server Security, Performance & Tuning (SSQA.net) : SQL Server: Monitor and Manage Database Maintenance issues - DBCC, backup and spotlight on tempdb and Transaction log backup performance
The subject line of this post is a common factor that every DBA might have (once in lifetime).  Performance Monitoring is a big subject when it comes to practice,  many factors include such as what to monitor, how often, and 'basic' rules of thumb. For the sake of performance you cannot simply compromise any SLA or Availability of application, there needs to be an effective approach to monitor and manage Database Maintenance issues in specific to DBCC,... (more)
category: News | clicked: 2 | comment | | source: sqlserver-qa.net
tags: applications, Best Practices, cpu, DMV, dynamic, kerberos, maintenance plan, Memory, performance monitoring, sla, SQL Server
1
kudos
spam Kudos Remove

Conor vs. Statement Offsets
published 343 days, 4 hours, 30 minutes ago posted by sasa 352 days, 2 hours, 11 minutes ago
Saturday, August 22, 2009 3:34:35 PM GMT Thursday, August 13, 2009 5:54:03 PM GMT
Conor vs. Statement Offsets
As most of you have figured out by now, I work mostly on queries :).  One of the things that I often need to do is to get a statement out of a batch so that I can go look more closely at a query plan (and, in my case, the code that generates it).    I use the a query like this to read through a few DMVs and emit the text for the plan I want:select statementstartoffset, statementendoffset, statementtext from ( SELECTSUBSTRING(st.text, (qs.statementstart_offset/2)+1,... (more)
category: Query | clicked: 2 | comment | | source: blogs.msdn.com
tags: DMV
1
kudos
spam Kudos Remove

When will my backup / restore / index reorganize finish?
published 361 days, 8 hours, 22 minutes ago posted by sasa 365 days, 5 hours, 46 minutes ago
Tuesday, August 04, 2009 11:42:41 AM GMT Friday, July 31, 2009 2:18:31 PM GMT
When will my backup / restore / index reorganize finish?
The DMVs are a great way to get a closer look at what is actually going on in your system.  In particular, for some operations, SQL Server populates the percentcomplete and estimatedcompletiontime (in milliseconds) in the DMV sys.dmexec_requests.  This can be very useful if you want to know how long your BACKUP or RESTORE will take (if you didn't use WITH STATS or are using command-line or a 3rd party tool), or whether you should go to lunch while your ROLLBACK is, well, rolling back... (more)
category: Management | clicked: 3 | comment | | source: sqlblog.com
tags: Backup, DMV, Restore