sqlservr.exe 100% utilization --- Urgent

Question

Post reply

sqlservr.exe 100% utilization --- Urgent

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 1

What is the max memory setting?

SELECT value_in_use

FROM sys.configurations

WHERE name = N'max server memory (MB)' ;

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Rajo SSC Enthusiast Points: 145 More actions · Answer 2

thanks for your reply,

memory is 16GB

here is problem wait stats is more .

Pls find the attachment

LutzM SSC Guru Points: 107049 More actions · Answer 3

And what are the results of the queries Nija asked you to run?

Please help us help you by providing the information that has been asked for.

If there's a reason you cannot run the queries, please let us know.

Right now we're at the point where all we can recommend is: get someone in to have a look at the system.

Regarding the value you just posted: is this the total memory of the server or the (converted) result of the query opc.three asked for?

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

LutzM (8/26/2011)
And what are the results of the queries Nija asked you to run?
Please help us help you by providing the information that has been asked for.
If there's a reason you cannot run the queries, please let us know.
Right now we're at the point where all we can recommend is: get someone in to have a look at the system.
Regarding the value you just posted: is this the total memory of the server or the (converted) result of the query opc.three asked for?

There's a reason I posted TWO scripts. They tell way way more than that jpeg ever will.

The query you ran doesn't tell what the REAL #1 wait it. Mine (edit from Paul Randal) does.

the 2nd 1 is all about giving a fairly good guess at what the threshold for parallelism should be. Can't do squat for you without that info.