July 21, 2011 at 1:58 am
Hi,
Actually, we have a development server having 6 instances running on it.( 3 OLTP and 3 OLAP mirrored).
Below is the configuration of server .
OS :Window server 2003 ent edition x64
Brand :HP proliant DL 360 G5
PRocessor : E5430 @ 2.66 ghz (4 CPUs)
Memory : 12 GB
I know 12 gb RAM is eye-brow raising concern.
Now following are the issues we are getting.
1. Some across server jobs are getting failed.
2. daily couple of jobs getting failed with error : ( unable to connect with sql server ) but no bad sign in system event log.
3. more often we get blocking , we force developers to stop there work then we have to kill some processes.
4 backup get failed on every second day.
i need to prepare one reports with some stats which can show lack of resources.
what are the tools like perfmon or DMV i can use to generate that report.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 21, 2011 at 2:16 am
Sorry i forgot to tell the memory distribution
instances :
1st : 2 gb
2nd : 2 gb ( mirrored from 1st)
3rd : 2 gb
4th : 2 gb ( mirrored from 3rd)
5th : 1 gb
6th : 1 gb ( mirrored from 5th)
OS : 2 gb
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 21, 2011 at 2:38 am
Maybe this can be a starting point:
- are your cpu-cores dedicated or do all instances compete for all cores ?
- what kind of io system / layout is in use ?
- the ram GB you mentioned: are the current taskmanager findings or are they set using max server memory ?
These inventory scripts may also help you build a decent view on the issues:
SQL Server 2005 Diagnostic Information Queries by Glenn Berry[/url]
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
July 21, 2011 at 3:27 am
ALZDBA (7/21/2011)
- are your cpu-cores dedicated or do all instances compete for all cores ?
we dont have dedicated CPUs
ALZDBA (7/21/2011)
- what kind of io system / layout is in use ?
i dont get you here ? please elaborate
ALZDBA (7/21/2011)
- the ram GB you mentioned: are the current taskmanager findings or are they set using max server memory ?
setting are from max memory.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 21, 2011 at 3:37 am
what errors do you get for the backup failure?
in regards to blocking, this should not be an issue it is an important feature of a RDMS, however if you mean dead-locks or blocks that hold for too long then in my experience i have found this relates more to the code than it does to server resources, a badly coded application can cause even the most powerful server to dead-lock.
so i guess i would start by looking at the causes of the dead-locks or blocks and the code and see what improvements could be made, before looking at what hardware you can throw at the problems.
July 21, 2011 at 4:29 am
Bhuvnesh (7/21/2011)
ALZDBA (7/21/2011)
- are your cpu-cores dedicated or do all instances compete for all cores ?
we dont have dedicated CPUs
ALZDBA (7/21/2011)
- what kind of io system / layout is in use ?
i dont get you here ? please elaborate
ALZDBA (7/21/2011)
- the ram GB you mentioned: are the current taskmanager findings or are they set using max server memory ?
setting are from max memory.
Raid level of the volumes ?
Dedicated disks per instance or shared by n instances ?
just pointing out where or how your instances can compete with each other, slowing down the whole.
it all may cause cpu queuing, disk io queuing, ...
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 - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply