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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-06-07 : 10:02:40
|
| Hi,In the task manager, I see sql server being used by SYSTEM and it is using about 3 GB of memory.How can I find out what it is that is using so much memory?Thanks |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-07 : 10:08:29
|
| Do you mean sql server is using a lot of memory?It will use as much as is allowed and will hang on to it as long as it can.If it's a problem then restrict the amount in server properties.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-06-07 : 10:27:53
|
| Yes, thereis about 3 GB of memory being used by sql server. And it is slowing the server down.This is on Dev machine. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-07 : 10:56:20
|
| Restrict the memory avaialable as above. SQL Server expects to be the only thing running on a server.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-06-08 : 00:03:08
|
| What is the total RAM on the machine ?Is it a 32 bit or a 64 bit ?After Monday and Tuesday even the calendar says W T F .... |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-06-08 : 09:40:59
|
| I have now restricted the memory on the server.Does it make a difference if the recovery model is full? |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-08 : 11:33:40
|
| No - that just affects the logs - you are taking log backups frequently aren't you?Hope this isn't a critical system.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-06-08 : 13:21:45
|
quote:
Originally posted by arkiboys
I have now restricted the memory on the server.Does it make a difference if the recovery model is full?
There is absolutely NO relation between recovery model and memory settings.After Monday and Tuesday even the calendar says W T F .... |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-06-10 : 03:18:22
|
| Thank you all. |
|
|
|
|
|
|
memory used