Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1617 > unrolled thread
| Started by | dbaonline99@gmail.com |
|---|---|
| First post | 2013-11-10 15:26 -0800 |
| Last post | 2013-11-10 15:28 -0800 |
| Articles | 2 — 2 participants |
Back to article view | Back to comp.databases.ms-sqlserver
how can DMV help for performance tuning ? dbaonline99@gmail.com - 2013-11-10 15:26 -0800
Re: how can DMV help for performance tuning ? kedar@techsql.net - 2013-11-10 15:28 -0800
| From | dbaonline99@gmail.com |
|---|---|
| Date | 2013-11-10 15:26 -0800 |
| Subject | how can DMV help for performance tuning ? |
| Message-ID | <525144fa-0471-41db-8006-9c913f4a3ef8@googlegroups.com> |
how can DMV help for performance tuning ?
[toc] | [next] | [standalone]
| From | kedar@techsql.net |
|---|---|
| Date | 2013-11-10 15:28 -0800 |
| Message-ID | <01ca367f-1876-4d17-825d-7e6b3d2e833c@googlegroups.com> |
| In reply to | #1617 |
On Sunday, November 10, 2013 5:26:32 PM UTC-6, dbaon...@gmail.com wrote: > how can DMV help for performance tuning ? DMVs are really useful for analyzing performance related issues. They help with below Identify Resource Consuming Queries query stats CPU consuming queries Index Usage Statistics You can refer below article for more information. http://www.techsql.com/sql-performance-tuning-with-dmvs.htm
[toc] | [prev] | [standalone]
Back to top | Article view | comp.databases.ms-sqlserver
csiph-web