July 13, 2015 at 9:03 pm
my sql server node was restarted & our colleague saying that sql server utilizing 95% memory & now i want detail about process which is running on that time & utilizing 95% memory
pls help me
July 14, 2015 at 12:44 am
giri10488 (7/13/2015)
my sql server node was restarted & our colleague saying that sql server utilizing 95% memory & now i want detail about process which is running on that time & utilizing 95% memorypls help me
Quick questions, what is the output of the following query and what are the server's memory specs?
😎
USE master;
GO
SET NOCOUNT ON;
SELECT
*
FROM sys.configurations SCFG
WHERE SCFG.name IN (N'min server memory (MB)',N'max server memory (MB)');
July 14, 2015 at 2:38 am
Unless you had some monitoring, it's unlikely that you'll be able to tell what the memory usage was at a point in the past. That said, it was probably SQL Server using the majority of the memory since, as was discussed in the other thread you posted, SQL uses all the memory that you allow it to.
So based on your previous statement
giri10488 (7/13/2015)
I have an issue with a server memory. SQL server is allocated 32 Gb out of 40 GB memory and sql server is using all the memory which is allocated to it.
SQL Server will use 80% (well, a little over due to the non-buffer memory), then you can add in the OS, any antivirus that's running, etc. Oh, and remote desktop, SSMS, etc if people there have a habit of remoting to production and working directly on the server
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2015 at 3:08 am
Is there any script to find out actual sql server memory utilisation?
July 14, 2015 at 3:11 am
Perfmon counter: Total server memory.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply