Contact Us

After my last post about monitoring deadlocks, I will now show a way to prevent deadlocks and unnecessary locks and to improve system performance. Introduction SQL Server has a lot of working mechanisms. The lock mechanism is one of the most important mechanisms. Its goal is to keep and secure the data reliability and consistency. This mechanism is very complex and depends on many variables. The mechanism is designed to let the system work in an optimal way. It is based on th

Three months ago, I presented a session at the special Rosh HaShana user group meeting. The session was about Monitoring Page Splits. I talked about the difference between a “real” page split (mid-page split) and a page allocation (end-page split). I demonstrated that all the tools available by SQL Server to monitor page splits actually monitor both types (mid-page and end-page), and there is no way to monitor only “real” page splits, which are a common concern for DBAs. I th

Profiler is a great tool. Everybody knows that. You can catch almost any event that occurs in the server while choosing the columns to display and filtering the results. It is very useful for monitoring and troubleshooting scenarios. But it is not included in SQL Server Express edition. Well, it’s a free edition, what did you expect? Recently I was asked to debug asp code that builds several query strings dynamically and propose alternatives that perform better. First I tried

In most sites I’ve been working at, developing Analysis Services solutions, most people were treating the Analysis Services server as a black box. Unlike the Database Engine, where DBAs knew their way around server and database settings and how to configure server properties in order to achieve high performing databases and applications, with Analysis Services it is usually not the case. In this article (and in future articles) I’ll try to shed some light on some important An