Baltimore-SQL-Business Intelligence Group

Next Meeting

Wednesday,

July

19

Regular Monthly Meeting

  • In-Person @ 10150 Old Columbia Road Columbia, Maryland, United States (map)
  • 18:00 - 20:00 Eastern Daylight Time
  • Language: English

6:00 P.M. - Socializing/gathering 

7:00 P.M. - SQL Server on your fingertips 

As a DBA, you know how hard it is to troubleshoot SQL Server issues and diagnose different possible problems. You know that you have to keep looking for multiple different aspects of the server including file sizes, memory consumption, CPU utilization, query compilations, locking, blocking, indexing and many more.

Sometimes you do not have right tools and sometimes existing tools do not provide you the full picture. The masterminds of SQL Server, such as: Paul Randal, Glen Berry, Benjamin Nevarez, Adam Machanic, Kalen Delaney, Jonathan Kehayias and others created wonderful set of queries to monitor your SQL Server instance and its surroundings.

I’ve just collected the best of those queries, combined them in relevant groups and assigned to SSMS hot keys.

In this presentation I will briefly show you the technology, we will go through all major troubleshooting functionality and you will learn how by just one press of a button get the most important SQL Server metrics on your screen.

Featured Presentation:

SQL Server on your fingertips

Slava Murygin, SQL Engineer SMC LLC

As a DBA, you know how hard it is to troubleshoot SQL Server issues and diagnose different possible problems. You know that you have to keep looking for multiple different aspects of the server including file sizes, memory consumption, CPU utilization, query compilations, locking, blocking, indexing and many more. Sometimes you do not have right tools and sometimes existing tools do not provide you the full picture. The masterminds of SQL Server, such as: Paul Randal, Glen Berry, Benjamin Nevarez, Adam Machanic, Kalen Delaney, Jonathan Kehayias and others created wonderful set of queries to monitor your SQL Server instance and its surroundings. I’ve just collected the best of those queries, combined them in relevant groups and assigned to SSMS hot keys. In this presentation I will briefly show you the technology, we will go through all major troubleshooting functionality and you will learn how by just one press of a button get the most important SQL Server metrics on your screen.

About Slava:
Started working with SQL Server 7.0 as DBA and Developer. Since then went through all SQL Server versions, migrations and multiple companies of different sizes and industries. Currently working as a contractor with all aspects of SQL Server, including, but not limited to: troubleshooting performance, designing/developing: databases, systems, processes, data warehouses, cubes, reports, ETLs; Refactoring old code; Migrating data from other systems to SQL Server; Securing the data on enterprise level.

PASSChapterLogo.jpg

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids