Hi all. I have SQL Server Standard Edition running on a Win 2k Server (3GB RAM, 2 x 2.4GHz). We are purchasing a new application and I am trying to determine if there will be enough memory available to add the db to this sql server box.
I ran some performance monitors and found the following info:
- Total & Target Server memory are both 1.7GB
- Available memory on server is ~1GB
- Pages/sec = .024
- Paging File: % usage = 13.5
- Buffer cache hit ratio = 99.8%
I'm just getting my feet wet with performance monitoring, but to me this data tells me that sql server is running fine right now. How can I estimate if there is enough room to add the db for this new application?
Any suggestions or references you can refer me to would be greatly appreciated!
I ran some performance monitors and found the following info:
- Total & Target Server memory are both 1.7GB
- Available memory on server is ~1GB
- Pages/sec = .024
- Paging File: % usage = 13.5
- Buffer cache hit ratio = 99.8%
I'm just getting my feet wet with performance monitoring, but to me this data tells me that sql server is running fine right now. How can I estimate if there is enough room to add the db for this new application?
Any suggestions or references you can refer me to would be greatly appreciated!