Author |
Topic |
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-03-04 : 05:55:03
|
sql server seems to be using a huge amount of ram & virtual memory - how can I get to the bottom to what is causing this? |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-04 : 08:35:05
|
Add a counter in performance monitor for SQL:Buffer manager and you can analyse how much memory is being used by SQL server. |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-03-04 : 09:14:28
|
how do i do that? this is on sql 2005where is performance monitor? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-04 : 09:21:47
|
http://www.windowsitlibrary.com/Content/77/15/1.html |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-03-04 : 10:57:43
|
but how do I even view the performance monitor? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-04 : 21:32:31
|
There are so many DMVs related to Performance in SQL Server 2005. Check out:www.Sql-server-performance.com |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-04 : 22:31:32
|
Sql will use all available memory on the server by default, it's normal. |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-03-05 : 02:26:10
|
is there anyway to restrict how much memory it uses?it's slowing everything else down. - and does it really need so much memory? |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-03-05 : 14:24:29
|
sorry to bump this but can anyone help?the sql is using all the memory and making the computer not usable - - i don't see where the performance monitor is on sql 2005 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-05 : 15:38:49
|
Type perfmon in Command prompt |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-05 : 15:53:33
|
You shouldn't restrict the memory unless there are other server processes on the box which is not recommended anyway. But SQL using all of the memory is completely normal, it's what makes SQL so fast! And it's isn't what is causing the computer to be unusable. Can you explain more?What else do you have running on this server?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-05 : 22:36:16
|
Set max memory with sp_configure if you really want to do that. |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-03-06 : 01:39:27
|
so then how can i pinpoint what it is.. i'm a programmer but the sys admin says somethign wrong that sql is using so much memoryit is a big database but i though sql should be able to handle it. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-06 : 01:41:23
|
As mentioned a few times already, this is normal. Why do you think this is a problem? Please answer the following questions so that we can help you further:What else do you have running on this server? You don't need to adjust the memory setting unless this is a cluster or you have other processes running on it. How big is the database? How much total memory do you have on the server? What size is the page file set to?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-03-06 : 03:49:21
|
What else do you have running on this server? You don't need to adjust the memory setting unless this is a cluster or you have other processes running on it. -- a lot it's an office serverHow big is the database? 400 mb i thinkHow much total memory do you have on the server? 4.00 gbWhat size is the page file set to? How do I check this? |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-03-06 : 06:13:41
|
does a larger db use up more memory? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-06 : 13:22:11
|
A 400MB database is small. Use sp_configure to change the max memory for the instance to 512MB (approximate guess on what you need).Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-06 : 22:12:41
|
>> i'm a programmer Then let your dba to handle it. |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-06 : 22:22:42
|
quote: Originally posted by esthera What else do you have running on this server? You don't need to adjust the memory setting unless this is a cluster or you have other processes running on it. -- a lot it's an office serverHow big is the database? 400 mb i thinkHow much total memory do you have on the server? 4.00 gbWhat size is the page file set to? How do I check this?
400 mb for an office server database? if this is a shared network directory or something, that could certainly cause some issues as it may be competing with a lot of other file operations. Something in the whole setup of this sounds way off...a large office would have server admins and DBA's for sure that should be able to handle this.. Poor planning on your part does not constitute an emergency on my part. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-07 : 01:34:34
|
I think you need to get a DBA to analyse: 1)major memory usage withing SQL Server. 2)Confirm server configuration.For example , some changed setting is killing memory3)Analyse the design and relevant workloadIf all the above is OK , consider moving SQL Server to it's own dedicated box Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-03-07 : 07:30:02
|
ok unfortunately no dba here.it's me the programmer and then the sysadmin who doesn't want to seem to touch sqlas far as Use sp_configure to change the max memory for the instance to 512MB (approximate guess on what you need).can i also configure the amount of virtual memory used? Is that possible? and how much of the cpu it can use? |
|
|
Next Page
|