March 11, 2004 at 10:14 am
I noticed one of my sql instances has no buffer cache, and all of the assigned memory is in procedure cache. (about 2 gigs). Is this a bad thing? I have been getting reports of slowness from users, but when I check the system monitor processors aren't ever going over 80%, usually around 30% - 40%. This is a dual 3.2 xeon server with 4 gigs of ram. Any thoughts?
March 12, 2004 at 4:20 am
How are you monitoring the sql memory, the situation you describe sounds unusual to say the least.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
March 12, 2004 at 5:18 am
I am using Embarcadero DBArtisan, but you can use "DBCC PROCCACHE" or SQL Performance monitor.
March 12, 2004 at 5:37 am
I notice you mention instance, are you running multiple instances on this server, if so each instance must have it's memory set and not use dynamic memory.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply