Slowness with SQL Server after a hardrive array recovery
Posted on 2013-01-19
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...