Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


SQL Server Performance Advanced Monitoring and Best Practices

(this is an on-demand video)

Sponsored by - IDERA

Webcast Abstract

Improving SQL Server performance by using advanced monitoring and best practices is key to ensure you rollout and maintain the best possible database solution. Continuing to use poor practices and a lack of monitoring is a sure way to eventually create major issues.

In this webcast we will cover several topics you can employ for a better SQL Server environment.

Some of the areas we will cover include:

How to increase your ability to track performance by expanding the use of existing features such as user defined performance counters, SET CONTEXT_INFO and newer execution plan DMVs.

We will cover common practices that leads to poor performance such as queries that use OR in WHERE clauses, not building updates that are in-place and not batching transactions.

Also, we will look at ideas to increase your performance by understanding when to use features such as table partitioning and in-memory tables.

Join us for this free SQL Server webcast.

Speaker - Mike Zawadzki

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.

More SQL Server Solutions

Learn more about SQL Server tools