Software offers better SQL server searches

Troubleshooting your database system when it’s having problems is no longer enough. With the recent onslaught of audit requirements, database administrators (DBAs) must stay on top of system and query performance on a regular basis in order to keep up with their environment as changes occur.

With the 2.1 release of Speed Coefficient, Imceda Software Inc. has greatly increased its graphical SQL Server trace tool’s performance, adding features that extend Coefficient’s baselining and troubleshooting capabilities well beyond those of Microsoft Corp.’s SQL Profiler. Without a doubt, this is the most useful trace tool I have ever seen.

Coefficient uses the same trace mechanisms that SQL Profiler does. In fact, a trace performed in Coefficient will produce the same trace files that one in SQL Profiler would. But unlike SQL Profiler, Coefficient loads the trace files into a database and aggregates the queries and their execution stats to give you an accurate, detailed picture of what’s going on within your database. It even picks through the miscellaneous SQL calls you would ordinarily have to pick through by hand.

Coefficient installs very easily; a few clicks and you’re done. Furthermore, it requires only a client-side install; nothing is needed on the server side.

After I installed Coefficient, I traced a server under very high user load. The process proved simple. You can configure Coefficient to trace in either Express or Advanced mode. Express mode asks for minimal input, then it quickly gets you on your way.

Advanced mode allows you to fine-tune every aspect of your trace; I was able to include and exclude users, programs and different trace elements, as well as set an amount of time for the trace to run. Coefficient also comes with a plethora of default trace templates and it allows you to define your own.

You may also choose to have Coefficient automatically analyze the data after a trace is complete. You can customize Coefficient’s predefined analysis templates to provide the level of detail you require and to filter out all but the specific problems you’re looking for. You may, for example, choose to see only those queries that use more than a certain amount of the CPU or that run over a certain time, or you may choose to see only security information or deadlocks.

As the analysis engine runs, it shows you what it’s doing every step of the way, which is especially helpful if a trace takes longer than expected. This feature is a significant improvement on the last version, in which the analysis wizard simply told you that it was “analyzing data.” Now you can easily be certain that your trace is making progress.

Coefficient’s tracing and analysis capabilities are standard; its true power resides in its reporting. Coefficient generates easy-to-read charts and tables. In a simple frame view, you can select subject areas and drill down deeply into details.

Coefficient also provides intelligent analysis. Its SQL Health section analyzes server workload and tells you how your stored procedures should be performing given the workload involved. The procedures that need attention are marked in red.

Coefficient does have its limitations. It doesn’t compare two separate traces, nor does it have a central repository. The tool also doesn’t allow for easy customization of the front end, nor does it allow you to schedule recurring traces. But Imceda says it will add these features and other ones later this year.

Overall, Coefficient does a much better job than the competition, and it’s definitely worth the investment while it’s still young.

QuickLink 057716

Would you recommend this article?


Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.

Jim Love, Chief Content Officer, IT World Canada

Featured Download

Featured Articles

Cybersecurity in 2024: Priorities and challenges for Canadian organizations 

By Derek Manky As predictions for 2024 point to the continued expansion...

Survey shows generative AI is a top priority for Canadian corporate leaders.

Leaders are devoting significant budget to generative AI for 2024 Canadian corporate...

Related Tech News

Tech Jobs

Our experienced team of journalists and bloggers bring you engaging in-depth interviews, videos and content targeted to IT professionals and line-of-business executives.

Tech Companies Hiring Right Now