We are using SQL 2008 64 bit.
We did several updates to our database in recent months, and reduced a size of the database from 30GB down to 3GB by deleting some archived data.
Performance of our IIS seems to have actually gotten worse. Are there any tools out there to analyze stored procedures, tables, queries to determine where a bottleneck may exist? Or do you have other ideas?
P.S. It is not the server hardware. We have a 12 core processor server with 48GB of memory and 15000 rpm hard drives. The Operating system is windows 2008 r2 64bit.