February 3, 2009 at 11:28 pm
Hi All,
[p]As i ran some DMV scripts to get server scope - Disk related IO information. I got the cumulative output like IO in MB and IO in Sec (The data in dmv’s would be result of data that is collected by sql server engine from the last restart).[/p]
[p]1.It is possible to get DMV results based on date/time specific.if yes how do we do that.[/p]
[p]2: is there any best performance benchmark values defined by industry for DMV results.[/p]
February 4, 2009 at 7:10 am
sobhan.sb (2/3/2009)
Hi All,[p]As i ran some DMV scripts to get server scope - Disk related IO information. I got the cumulative output like IO in MB and IO in Sec (The data in dmv’s would be result of data that is collected by sql server engine from the last restart).[/p]
[p]1.It is possible to get DMV results based on date/time specific.if yes how do we do that.[/p]
sys.dm_io_virtual_file_stats - IO statistics for databases and log files[p]2: is there any best performance benchmark values defined by industry for DMV results.[/p]
1. From the DMV you're using, no, you can run it once a day and be able to compare to a previous run.
2. Not really. Your disks, memory and CPU have a set of expected behaviors when combined, but then you have to take into account the database design, queries, indexes, statistics, load of other applications (if any) on the server...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply