September 5, 2012 at 11:42 pm
HI
1.Can any one say how to find [or how we can know ]the utilization is high while we are running performance monitor with sql server buffer manger and read/io and write/io counter added in the perfmon
Thanks & Regards
NAGA.ROHITKUMAR
Thanks
Naga.Rohitkumar
September 6, 2012 at 9:50 am
The utilization of what? The word "utilization" does not mean anything by itself, it has to be applied to something, like a resource. "High CPU Utilization", "memory utilization", "disk io utilization", these all mean something.
Currently, your question is too ambiguous, so please explain more.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
November 7, 2012 at 9:58 pm
i mean cpu utilization, or physical IO etc
and another thing
1.what can as a DBA we can look care for performance improvement of a server which is running sqlserver
2. for performance issues like application team or client complains that for query execution it is taking so long time
in this scenario what should i do or follow by which this issue may solve and for query execution makes faster what i have to do
3.my DL have asked me to suggest some performance related ideas which may sort out this point 1 and point 2 types of issues
Thanks
Naga.Rohitkumar
November 9, 2012 at 4:18 am
naga.rohitkumar (11/7/2012)
i mean cpu utilization, or physical IO etcand another thing
1.what can as a DBA we can look care for performance improvement of a server which is running sqlserver
2. for performance issues like application team or client complains that for query execution it is taking so long time
in this scenario what should i do or follow by which this issue may solve and for query execution makes faster what i have to do
3.my DL have asked me to suggest some performance related ideas which may sort out this point 1 and point 2 types of issues
here you can spend years to explain OR study about these terms .. your DL(TL) actually looking you as a consultant.:hehe:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 11, 2012 at 9:47 pm
ya but iwant to survie inthe client location which is now exploring more issues which i might not konw which i am learning from few months so idonw wnt to miss this opprtunity in my early stage hadling 4 + of work as a l1 and very rarely l1 will handel [4+]this l2 sorrt of work.
if u can suggest technical advices rather than genral things its will be nice, and Its happens in everyonces life
Thanks
Naga.Rohitkumar
November 11, 2012 at 11:12 pm
naga.rohitkumar (11/11/2012)
if u can suggest technical advices rather than genral things its will be nice, and Its happens in everyonces life
see these links
http://support.microsoft.com/kb/298475
http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply