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 |
|
reddy_vam
Starting Member
43 Posts |
 Posted - 2012-09-05 : 12:52:44
|
| Hi All,We have a SQL Server 2008 server with about 3 database on it.We allocated 26 GB to SQL Server (Max server memory) out of 32 GB RAMThe Server is currently running very slow and running low on memoryIs there anyway I can find that how much actual memory SQL Server is using out of 26 GB RAM ? |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-05 : 12:57:57
|
| How are you determining that it is low on memory? Look at Perfmmon SQL Memory Manager->Total Server Memory that will tell you how much SQL is using. -Chad |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-05 : 14:03:23
|
| In the Performance object: process , check the counters (Private Bytes ) and (Working Set) . Private Bytes present scurrent amount of memory commited , Working Set presents the physical meot amount . Check to see if other applications are using excessive memory - such as Anti Virus etc. How do you know the issue is memory pressure?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Find SQL Server Memory Usage