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 |
|
svicky9
Posting Yak Master
232 Posts |
 Posted - 2006-05-24 : 05:24:28
|
| Hi Guysi am trying to check some counters on the Sql Server Performance Monitor .I was checking the pages/sec from the memory counter and it gives me 100% baseline on the graph.Any ideas of why this is happening and how can i sort the problemThanksVic |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-05-24 : 06:51:54
|
| What do you mean by "100% baseline"? Performce monitor reports paging as pages per second, not a percentage.CODO ERGO SUM |
 |
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2006-05-24 : 06:57:06
|
| Is this server dedicated to SQL Server or are you running other apps on it? |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2006-05-24 : 07:51:06
|
| there are no other apps only sql server...sorry its the pages/sec not the percentageVic |
|
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2006-05-24 : 08:35:36
|
| Do you see anything unusually high in task manager>processes Mem Usage? |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-05-24 : 13:37:06
|
| Don't look at the graph. Look at the numbers in the text boxes for the graph.Most things have values over "100" (Network traffic, disk read/write bytes/ sec, etc). In this case, I think you are over "100" but that may not mean "I'm at 100% of the pages per second that the machine can do.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. |
|
|
|
|
|
|
pages/sec