Post reply

Possible database errors/flags to check and clean

  • September 17, 2015 at 11:04 am

    #320715

    I am looking to find out Possible database errors/flags and clean the environment :a few like below

    Auto-growth should be MB not in %

    Database Compatibility levels should be same

    Disable/Drop logins which are no longer useful

    Clean all the Disabled Jobs on SQL Server Agent

    Backups, DBCC, Index,Stats--should have managed well with proper timings

    Tempdb files and ldf files on faster drives

    can any one share a few more ?

  • September 17, 2015 at 11:14 am

    #1827504

    Full Recovery or Not

    Proper transaction log backups for full recovery model databases.

    Set Maxdop setting per http://support.microsoft.com/kb/2806535

    Set Cost Threshold for Paralellism

    Set OS power options to high performance

    Enable optimize for ad-hoc workloads

    Split Tempdb into multiple files

    Enable Fast file initialization

    Assign the Lock pages in memory user right

    Here are some others I always check. I would love to hear feedback on these from others.

  • September 17, 2015 at 11:41 am

    #1827511

    Worth looking looking at Brent Ozar's sp_Blitz, if you haven't already.

  • September 17, 2015 at 12:41 pm

    #1827537

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply