Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Scripts with tag
DMV
Search for
any
content tagged
dmv
Add a script
Items 1 to 7 of 7
Get Top Queries Taxing SQL Server CPUs
Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.
Read more...
By
Prakash Heda
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
2,228 reads
What Is Filling Up The Transaction Log
Report unusual conditions that may be filling up your transaction log.
Read more...
By
SQL Scripts Manager dev team
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
4,166 reads
Signal and Resource Waits
Calculates the signal and resource waits as a percentage of overall wait time.
Read more...
By
SQL Scripts Manager dev team
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,135 reads
Missing Indexes By Index Advantage
Identifies potentially missing indexes.
Read more...
By
SQL Scripts Manager dev team
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
3,369 reads
List Unused Tables and Indexes
Finds tables and indexes that do not show up in the usage statistics.
Read more...
By
SQL Scripts Manager dev team
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
2,867 reads
Clear Wait Statistics
Clears the wait statistics so that the results of the 'Signal and Resource Waits' scripts are more relevant
Read more...
By
SQL Scripts Manager dev team
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,320 reads
Aggregating Index usage information
This script aggregates index usage stats into a view.
Read more...
By
sql frenzy
2008/11/25
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
1,139 reads
Items 1 to 7 of 7
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.