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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2006-09-25 : 01:13:31
|
| Hi allWe create a baseline for performance monitor for in our SQL environment and log into SQL database. The monitor is conducting in the client machine not in the actual server. Couple question regarding performance monitor:1. % Disk Time. This indicator seems doesn't work for the disk that attach to SAN. So how do I get the similar indication. 2. There are 4 extra figures: FirstValueA, FirstValueB, SecondValueA and SecondValueB for indicator: Bytes Total/sec, % Disk Time, % Processor Time, Lock Waits/sec. What this figure represent to?Thanks |
|
|
Luis Martin
Yak Posting Veteran
54 Posts |
Posted - 2006-09-25 : 09:41:16
|
| 1) Whit SAN, performance monitor does not work well.2) Bytes Total/sec = reads and writes, % Disk Time (With SAN, ?), % Processor Time = % of time used by ALL Processor for all process. Lock Waits/sec = How many locks are waiting per second. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-09-25 : 12:56:56
|
| Two things:1. If your SAN has a perfomance monitor tool built into it, use that.2. Counters to monitorUnder Physical disk look at the following counters for each "drive" of server that is attached to the SAN.Average Disk Queue Length (this should not exceed 2.0 for extended periods of timeDisk Read Bytes / secDisk Write Bytes / secThat should give you a good starting point.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
|
|
|
|
|
Performance Monitor