Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Slowness with SQL Server after a hardrive array recovery

Posted on 2013-01-19
12
330 Views
Last Modified: 2013-01-28
We are running SQL Server 2005 on a SERVER2008 HP box.  We had a hot swappable drive go bad and replaced it.  Using the HP array recovery process the drive was successfully recovered/rebuilt and the server itself is running problem free.  However, SQL Server has been running Extremely slow ever since the drive was recovered.

Does anyone know if we must do some sort of optimization of our SQL Databases or if we must do a SQL restore after the array rebuild to help with our slowness?

Help...Open to any and all suggestions...
0
Comment
Question by:VHM1
  • 5
  • 4
  • 2
  • +1
12 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38796791
Have you tried updating stats or rebuilding/reorganizing indexes?
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38796801
if HP array recovery is completed (how big\fast disks there? what Raid? did you add the same speed size disk as you had?)


... you can try to ran DB maintenance for the affected databases: integrity check; reindex; update stats for start.

also check if you have some slow running queries;
check sql server errors? Event viewer related errors?
check if your HP firmware is up to date

did you reboot the server ?

how is CPU \Memory utilization? any IO errors?
0
 

Author Comment

by:VHM1
ID: 38796803
Yes, we have done both.  We do that regulary anyway.  They jobs to do these run almost 3-4 times longer since the drive was replaced.

All SQL interaction runs 2-4 times longer since the drive was replaced.
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:VHM1
ID: 38796805
server has been re-booted several times since the successfull rebuild.  Firmware is up to date.  Machine is working fine and showing no errors or SQL errors.
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38797313
how is antivirus doing? is set to exclude sq server files,etc?

what is CPU /memory utilization on this box ?
can you run sp_configure  to see max dop ?

can you give details "running Extremely "  what is running slow?
0
 

Author Comment

by:VHM1
ID: 38797334
Sql jobs that ran for seconds before are now running in 45 minutes to 2 hours.  Example, we do transaction logs each 30 minutes.  They ran for seconds before the drive was replaced, now they run 30+ minutes.

CPU and Memory is normal and good.

What is SP_configure?
0
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 250 total points
ID: 38797369
are you sure that raid rebuild is complete?  what drive did you put : same as was?
what db (s) set on this drive?

also run xp_readerrorlog from ssms to get sql error log info

sp_configure
http://msdn.microsoft.com/en-us/library/ms188787.aspx
0
 
LVL 24

Assisted Solution

by:DBAduck - Ben Miller
DBAduck - Ben Miller earned 250 total points
ID: 38810125
Have you stopped SQL Server and defragmented the hard drives that SQL data files are on?  You could have a great amount of fragmentation on the hard drives that could be causing this problem.  I would start there to ensure that the foundation is sound.

Then I would look to see if the Indexes are fragmented (sys.dm_db_index_physical_stats) and if they are I would defragment them.

Then I would chase other ghosts.
0
 

Accepted Solution

by:
VHM1 earned 0 total points
ID: 38810513
Thanks.  Issue was 2 fold...#1, when the array re-built itself, it set the array settings back to the default values (thus turning off write cacheing).  #2 was that the array software used to rebuild the drive was not set to handle open SQL files and as a result it fragmented things greatly.  Products like disk-keeper should be used to handle the rebuild.

THanks for everyones help.
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38812402
cool
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38812685
Thanks.  Issue was 2 fold...
Excellent!  Now please close the question.  This is how it is done:
Closing
http://www.experts-exchange.com/help/viewHelpPage.jsp?helpPageID=24
0
 

Author Closing Comment

by:VHM1
ID: 38826210
My solution is what resolved our specific issue.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question