Israeli SQL Server User Group

Welcome to Israel SQL Server PASS Chapter homepage.

Our sponsors:





Next Meeting

Next meeting




Top Performance Killers and Killer Scripts to Find Them

  • In-Person @ 2 HaPnina St. Raanana, HaSharon, Israel (map)
  • 04:00 - 06:00 Jerusalem Daylight Time
  • Language: English

1. Top 10 SQL Server Performance Killers – Vitaly Bruk (60 Minutes, Hebrew)

There are so many tips and best practices out there for boosting the performance of your SQL Server instance. With so many tips and resources, it’s difficult to decide which are correct and where to start.
Vitaly Bruk is going to share his experience and present his list of top 10 performance killers in SQL Server. These are the things you should avoid. Some of these performance killers are quite common, and there is a good chance that you have them in your SQL Server instances.
Here are some examples: Default vs. Best Practice Instance Configurations (Min/Max Memory, Max DOP, Cost Threshold for Parallelism, etc.), Statistics Maintenance, Wrong Data Types.
Join this session to learn why these performance killers are so bad for your system and what you should do in order to avoid them.

2. 4 Killer Scripts that will Pinpoint any Real-Time Performance Issue in Your Database – Michael Zilberstein (60 Minutes, Hebrew)

Does any of these sound familiar?
• Database is stuck, CPU is skyrocketing, but you don't see anything particularly heavy running on the system.
• Everything looks heavy and stuck.
• Server looks idle, but database operations fail with timeout.
In this session we will demonstrate a set of useful scripts that will assist you in pinpointing the troublemaker in any given scenario: single heavy stuck query, blocking locks, or lots of small queries that drive CPU crazy. Your DBA life will be much easier with those scripts in your toolkit.


Israel Blogging Community:

Guy Glantser Dubi Lebel Matan Yungman Meir Dudai Geri Reshef Maria Zakourdaev Noam Brezis Eitan Blumin Asaf Aviv Michael Zilbershtein Itai Binyamin Ronen Ariely Pini Krisher




SQL Joke of the month:

DBAs make the best husbands. They understand relationships and know how to commit

Back to Top