SQLChamp

Best Practice No.11

Configure your anti-virus to exclude all your Database related files namely (mdf, ndf, ldf, trn, bak, log, tuf and other

Keep Guest account disabled for all your User Databases.

I’ll be delivering another webcast in Lunch Time series and this time its on How to Monitor SQL Servers using

Provide appropriate Fill Factor while creating\rebuilding Indexes to avoid\minimize fragmentation.

Make sure Auto_Close is disabled for all Databases on your Production Servers.

Make sure you configure SQL Server to run on a NON Default port.

Keep Backup and Database files on separate disk to avoid single point of failure.

Keep VLF Count in check for all your transaction log files. Too many VLFs can cause slow DB Recovery &

Use Set NOCOUNT ON for all Batches, Stored Procedures and Triggers to reduce Network traffic for SQL Server.

Grant Granular access whenever possible to avoid providing elevated access.