VLDB Maintenance Best Practices

Microsoft’s Paul Randal has a good post with a list of common sense practices for maintaining very large databases. I have personally seen the problems that heavy index maintenance can cause when database mirroring is turned on (especially if you have less IO capacity on the mirror side than on the principal side).

At any rate, this is a good best practices list.

Technorati Tag: SQL Server

This entry was posted in SQL Server 2005. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s