SQL Server Performance
Posted on 2012-08-13
We have SQL Server 2008 R2 running on Windows Server 2008 R2 and have a custom built SQL database running that is accessed from an ASP web interface.
There are two identical sites configured (on different ports) that access two different SQL databases (that were identical when setup but now contain different sets of data, but both databases have a similar volume of data - around 1500 client records). These two sites are configured to store data for two different geographical client data sets (One for North, one for South).
We have performance issues when browsing through just the North sets of data. Performing the same browsing and searching on the South, it works quickly whilst on the North it takes 10-30 seconds to navigate the data.
We have checked the server performance (CPU, RAM, HDD activity, Networking, etc) and nothing is overworked when the issues occur in the North data (or ever, this was a new server to try and improve the performance as these issues existed on a previous Windows Server 2003 machine with SQL Server 2000).
We have also tried stopping all of the services for the South database and site and the issues still persist with the other data set. The server is not performing any other roles at all.
We have also performed all SQL Server maintenance tasks to compact and tidy up both databases and the transaction logs and fully re-indexed both. The server has been rebooted following all of these tasks but the performnce issues in just one database persists.
The data is located on two separate RAID arrays, one for the transaction logs and one for the databases.
Does anyone have any insight or suggestions as to what we can do to improve the performance of accessing data in the one site (that is virtually identical to the second site in all but the data records - which are all simple text fields with minimal data - less than three sentances)?