Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2006-09-21 : 12:38:35
|
I've setup perfmon to look at some counters and now that I have a full day or more of data, I'd like to review it. The problem is that perfmon is very limited. I cannot specify a date to start or to end. The timeline is a slider control and jumps 3 to 10 minutes at a time. Is there a better tool out there to view the perfmon logs with? I need the fancy graphs (Upper management likes pretty things to look at  ) along with averages just like perfmon has; however, I need to specify specific time periods to review which perfmon has issues with.The end goal is that I need to show the disk bottleneck on our SQL Server so the approval of a new array can go through.Thanks... |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-09-21 : 13:13:02
|
| You can either import your PerfMon files to SQL Server or have PerfMon write directly to SQL Server. Then the data is easily queried.You can always use RS if you need a fancy chart. |
 |
|
|
|
|
|
Reviewing a Perfmon log?