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 |
|
peera
Starting Member
11 Posts |
 Posted - 2003-11-13 : 14:44:54
|
| Hi,i am using smart dba cockpit it shows the cache hit ratio is too low "error" like 63%. becoz it says it should be >80% how do i fix this.thx |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-13 : 14:48:24
|
| Add more memory to your server. If the value is below 95% consistently, I would recommend adding more memory as well. 80% is just too low of a threshold. How much RAM do you have on your server? How big is your database?Tara |
 |
|
|
peera
Starting Member
11 Posts |
Posted - 2003-11-13 : 14:51:12
|
| the db size is 526MB and 1GB RAM! thx |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-13 : 14:53:35
|
| Is it a dedicated SQL Server, meaning no other software is being used like IIS or other user applications?Tara |
|
|
|
peera
Starting Member
11 Posts |
Posted - 2003-11-13 : 14:56:20
|
| yes ur rite! just sql server nothing else.thx |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-13 : 14:57:55
|
| The only way that you are going to get the cache hit ratio to go up is to tune your queries and/or add more RAM to the server. You might want to consider running SQL Profiler to trace the sql activity.Tara |
|
|
|
|
|
|
cache hit ratio