Tool to measure Index Selectivity
by Michal Tinthofer on 05/06/2012Sometimes when you plan to change your index design is good to know the columns of your tables. But not just a data type and max size.
Read moreDear SMT users,
After about two months we have another update for Server Monitoring Tool available for you. The version is now 00.5.70 and the updates are ongoing. Some of our clients have already been informed in a bit more detail about the changes by one of my colleagues on a regular meeting, the rest will get the introduction on the upcoming session.
Here is a brief summary of all the changes included.
For the new reports we tried to add enough information to make it easier for you to use those.
Please contact us in case you have any questions or suggestions, we would be happy to discuss them.
We will start scoping a new release soon. I am sure that a another set of helpful stuff and enhancements will be delivered for you to us in SMT.
Kind Regards,
Jiri Dolezalek
Michal Tinthofer is the face of the Woodler company which (as he does), is fully committed to complete support of Microsoft SQL Server products to its customers. He often acts as a database architect, performance tuner, administrator, SQL Server monitoring developer (Woodler SMT) and, last but not least, a trainer of people who are developing their skills in this area. His current "Quest" is to help admins and developers to quickly and accurately identify issues related to their work and SQL Server runtime.
Sometimes when you plan to change your index design is good to know the columns of your tables. But not just a data type and max size.
Read moreWhen investigating performance degradation in SQL Server, we often look at missing indexes, outdated statistics, or bloated execution plans. However, sometimes the root cause lives entirely outside the database engine...
Read moreDuring last SQL Server Bootcamp 2024 in Brno - our colleague Jan Repka presented a live query tuning session.
Read more