February 11, 2015 at 12:29 am
Hi all
Please tell me the which values are best prepared value for given below memory objects
Memory
Parameter
Total memory=
SQL Cache Memory=
Lock Memory=
Optimizer Memory=
Connection Memory=
Granted WorkSpace Memory=
Memory Grants Pending=
Memory Grants Success=
Cache Details:
Cache Hit Ratio=
Cache Used/Min=
Cache Count=
Cache Pages=
Scheduled Jobs:
Job Status=
Run date & time=
Job Time=
Retries Attempted=
Please anyone can tell me the above performance counters prepared values
thanks advance
February 11, 2015 at 12:47 am
Hi - please don't cross post - it does make your job of getting the correct answer harder.
Which version of SQL server are you using? you asked in forums for different versions.
What have you done thus far to get the information you need?
For the job information have you look at msdb..sysjobs ?
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
February 11, 2015 at 3:00 am
Hi davies
i dont know what the preffered values of above objects so, anyone can help me i will enable the counters in sql server and i am using sql server 2008r2
thanks advance
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply