What is exactly meant by Performance Tuning a database? I have a db in which
the data is truncated and inserted every week. I do the DBREINDEX after the
data is inserted. Is there anything else that needs to be done to performance
tune the db?

Hi
It is very big and important subject. Do you run SELECTs? Have you seen
performance decreasing?
Use of effective indexes will speed up the queries a, another factor is
memory /hardware and many optiot to be configured.

BTW , there is no wisdom to rebuild every table , identify fragmented tables
and then run DBCC, more over make sure that  you create a clustered index io
the 'right' column to reduce fragmentation

http://www.sql-server-performance.com/









Show quoteHide quote

Also, check the query execution plans to see if new indexes are needed and
existing indexes are being used as expected.

Show quoteHide quote

The subject is more interesting the larger and more complex the database.

Get it up to hundreds of tables, hundreds of gigabytes, thousands of SPs,
twenty guys writing it, ... dbas accidentally dropping the PKs, ... thousands
of transactions per minute in unpredictable patterns, ... Microsoft service
packs causing new behaviors, ... keeps a fellow busy.

Josh


Show quoteHide quote

Your best course of action is to hire a performance tuning expert to give
your systems a review and mentor you while doing this.  Win-win for you and
your company.

Show quoteHide quote

sys.sp_dbmmonitor* procedures missing from msdb at mirror
Should I enable AWE on 32-bit SQL 2005 EE running on 64-bit Window
Insert & Update Triggers.
Impact of using Varchar as Opposed to using NVarchar
fk is not a constraint!!!
List of Tables in a FileGroup
Restore a 64 bit backup to a 32 bit server?
Define a "user" in the license policy.
HELP - SQL QUERY
Quest vs Idera