September 19, 2008 at 1:19 am
Hi,
There are 4 servers that i have that are connected to a SAN drive. 2 of them have SQL server 2005. SQL jobs have been running quite quck and users have not been complaining about performance. We got some consultants during the course of this month to change the configuration of the 4 servers as to how they connect to the SAN drive. At the moment performance on these boxes is slow. Queries take time to run and some jobs are slow. Users complain of their machines hanging at rougly the same time each day, (10 am, 3-5pm). I tried to monitor the server cpu usages, processor times and disk usages on the sql server boxes. Processors show high usage rates and the disk activity is high as well. Could it be the changes which the SAN consultants did or that the servers are now not coping with the stress being applied to them?
Please help
Tendayi
September 19, 2008 at 2:37 am
I suggest to ask these consultants what they did. Do you have a SAN administrator in your company? Maybe he implemented some job on the SAN box (i.e. some synchronizing actions, or background backup operations)
It also might be a SQL issue. I don't know how you manage your SQLservers, but here a my 5 cents:
- Make sure database statistics and indexes are up-to-date
- No errors are reported (both SQL, windows and from your SAN controller)
- Did the number of users change?
- Did the salesdepartment/management/... implement a reporting tool? :w00t:
- Network changes? Other cards, full/half duplex configurations ok?
- Latest, supported (SAN) drivers installed?
Good luck
Wilfred
The best things in life are the simple things
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply