Today is my 900th article on this blog. You can see list of all the 900 articles here. I suggest you go over the list and read any article you like.
First let us go over 9 Best Practices List.
- Auto Shrink runs at regular interval (30 mins) in background of SQL Server and it is cause performance dropping fragmentation. It should be turn off.
- All the statistics should be updated at regular interval.
- Compressed backup should be used instead of regular backup as it improves speed and performance. Restoring compressed backup is faster than regular restore.
- Always take full database backups along with differential and log backups. Log backups can be very much useful for point-in-time recovery.
- Pay attention to “Activity Monitor” – a new feature which displays current activity of a) Process Time, b) Waiting Tasks, c) Database I/O, d) Batch Requests/Sec.
- Control the configurations as well enforces policies using Policy Based Management.
- Utilize new datatypes DATE and TIME instead of conventional DATETIME.
- Keep database updated with latest SPs and Cumulative Updates.
- Use Dynamic Management Views to figure out longest running queries as well most popular queries.
Social Media is new thing and I am really enjoying to be part of it. Twitter, LinkedIn, Facebook, Feedreader are my latest interests. Here is my web presence in social media.
Best thing about my job is I can work from office as well as from home office. Find me in action at home office.
Reference : Pinal Dave (https://blog.sqlauthority.com)