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-26 : 14:20:33
|
| Hi GuysWhat does the Running values under the Sql Server properties indicate?Is it configuring the Sql Server to run with the current set of values??? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-26 : 14:22:10
|
| Running values means that those are the paramters that SQL Server is using. Current values will include any changes that you have made but have not taken effect since the service wasn't restarted yet. Both values will often be the same unless changes have been made without a restart.Tara Kizeraka tduggan |
 |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2006-05-26 : 15:21:04
|
| Hi TaraWe have an Windows Server 2003 dedicated to the Sql Server 2000.I was checking the performance monitor of the Sql Server for the Memory.Every now and then we are experiencing the Page Faults on the performance monitor...What could be the problem.VicVic |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-26 : 15:22:27
|
| That is normal. Page faults will happen. What values are you seeing?Tara Kizeraka tduggan |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2006-05-26 : 15:28:37
|
| oh ok...it occasionally touches the Top mark(100) and comes back to 5%average : 593Maximum :6792Minimum :44Duration :1:40Vic |
|
|
|
|
|
|
Running Values