?
Solved

T-SQL script that list average I/O per table for each database

Posted on 2012-09-11
2
Medium Priority
?
531 Views
Last Modified: 2012-09-25
I have about 50 SQLServer servers with about 10-25 databases on each. I would love to have a query that I can run to list not only each database, table and rowcount but also average I/O for each so I can determine how the databases are used or how much rather. Anyone have anything like this?
0
Comment
Question by:cheryl9063
2 Comments
 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 1000 total points
ID: 38388342
Try looking at Red Gate's  SQL Monitor
0
 
LVL 9

Accepted Solution

by:
Vijaya Reddy Pinnapa Reddy earned 1000 total points
ID: 38388625
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Screencast - Getting to Know the Pipeline
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question