SQL query time
Posted on 2011-09-13
We have a custom app written in ASP.NET 3.5 and C+ that we interface via Internet Explorer on our desktops. It uses a SQL database on our SBS 2008. Some of the queries take 30-60 seconds and I would like to speed that up. One option I am looking at is to change over to a SSD on on the server, as I feel the RAID 5 is contributing to the slowness. Any SQL experts want to give input on what I should look at, whether to upgrade to an SSD or whether to have a look at the SQL code?