MS Webcast | Lunch Time – How to Monitor SQL Servers using Powershell – Part 1 | 26-June-2013

I’ll be delivering another webcast in Lunch Time series and this time its on How to Monitor SQL Servers using Powershell – Part 1. Join this webcast to learn how to create your own monitoring solution for SQL Servers using Powershell.

About the Session: Monitoring and Alerting is a vital process of every IT Pro and if you are managing more than just a couple of SQL Servers it becomes indispensable. This webcast will guide you and explain the ted-bits about creating your own Monitoring Solution. This will work as a Ice-Breaker session for those who don’t know much about PowerShell and how to use PowerShell to create your own customized monitoring\alerting solution.

To Register visit:


Best Practice No.9

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

Best Practice No.8

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

Best Practice No.7

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

Best Practice No.6

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

Best Practice No.5

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

Best Practice No.4

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

Best Practice No.3

Grant Granular access whenever possible to avoid providing elevated access.