April 14, 2011 at 1:46 pm
How long since the box has been rebooted and how big the db size to be loaded.
Are your indexes fragmented ?
In that case, your engine will need to perform more IO than strictly needed to get to your data. It may even not use relevant indexes (if optimized) at all.
Are all databases back online, or is it still restoring some ? (redo logs / rollback open trx on boot time)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 14, 2011 at 1:51 pm
I find this article very helpful:
"A Small Collection of I/O Specific DMV Queries"
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!2991.entry
By Glenn Berry
There is also a WP to help understand what's going on:
WP SQL2005 Performance_Tuning_Waits_Queues.doc
And for refs I find Quest - SQL Server Perfmon Counters Poster.pdf very nice.
And of course "Wait statistics, or please tell me where it hurts "
http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 14, 2011 at 1:57 pm
Okay, I am a bit confused here. In your original post, you stated that SQL Server was granted 44GB of memory, then your latest states 48GB - but, the Target Server Memory is 52GB.
I noticed that you stated you are using Standard Edition - not sure if you stated that you have the enabled the trace flag that allows lock pages in memory to be used. If that has not been done, then it is very likely that SQL Server is paging out the working set. You can validate this by looking in the SQL Server logs for any messages related to this.
If you do have the trace flag set and it really is enabled - then I just missed it.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 14, 2011 at 4:38 pm
Hi Pat,
I have question, I see the query which you have provided gives us the value of Target SQL server memory in cntr_value.
How do I convert it to confirm if its the same value in sp_configure or the perfmon.
April 14, 2011 at 11:18 pm
Hi,
it is the same value in sql server and in system monitor. Only if in the sys view with the performance counters a counter exists with a base ending, you must calculate the value like buffer cach hit ratio. Keep in mind that the values of the perf counter view are only a current snapshot of them.
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
April 15, 2011 at 12:00 am
zygonr (4/14/2011)
Hi Pat,I have question, I see the query which you have provided gives us the value of Target SQL server memory in cntr_value.
How do I convert it to confirm if its the same value in sp_configure or the perfmon.
have a look at http://www.sqlservercentral.com/Forums/Topic107424-65-1.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply