Home > Archive > MS SQL Server > March 2006 > Re: Isn't my SQL Server hardware sufficient for my server load? Why does it keep getting slow?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: Isn't my SQL Server hardware sufficient for my server load? Why does it keep getting slow?
Doug

2006-03-25, 1:23 pm

Try removing indexes on your OLTP databases.

On your largest tables, what are the indexes currently? Clustered?

Most trans tables have an index to help find duplicates, and entries
already there. You need this index, but all others should be suspect.

Indexes slow inserts. OTOH, indexes speed up lookups and reports. It
can be a pretty fine line of balance between the two.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com