We're having some major issues with our database. We can navigate the website just fine, but when we attempt to do updates, the requests are timing out. Some tables in the database are over 5 million records big. That's not really huge, so we don't understand what's going on.
Someone suggested dumping the database, deleting the database from the SQL server group in Enterprise manager, recreating the database, and then attaching the databaese files again. Will that resolve anything?
How about doing a full backup and restore? Does that defragment the database? Or is that a waste?
Any suggestions would be great.
Oh I already tried optimizing/shrinking/etc...seems to help for 2 minutes, then it's back to a flat-line :(