Select Page

SQL Profiler vs. Extended Events: Time to Switch?

Andy McDermid | | September 23, 2014

Many people working with enterprise technologies live by rule, “if it ain’t broke, don’t fix it.” But when tools and technologies become obsolete – as has occurred with several popular tools and is destined to affect Microsoft SQL Profiler – we need to adopt new technologies.

If your troubleshooting tools and techniques are working and you are using the most current technologies available, great! If you are still using outdated and obsolete tools, you need to look at other options.

Our experience with Microsoft’s Extended Events is a great example. Extended Events has been around since 2008. So what took us – OK, not just us, everyone! – so long to get on the Extended Events bandwagon?

We at Datavail don’t have a good excuse for delaying and dithering. “If it ain’t broke, don’t fix it” has been working fine for us. SQL Profiler still works. It’s a tried-and-true testing technology that’s been around forever. It’s quick, comfortable, familiar, and easy to use.

The problem with SQL Profiler is that it is becoming obsolete.

Moving from SQL Profiler to Extended Events

If we don’t remember the pain associated with using a technology or application well past its usefulness, then we are destined to repeat our mistakes. You also stuck with WordPerfect and Windows XP until the bitter end, didn’t you? Remember how those relationships ended?

Move on! Using new tools and technologies is an advantage for you and your organization. If you want to grow in your profession, you need to get out of your comfort zone by working with new tools. New tools exist for a reason: They are a marked improvement compared to existing technologies.

Proactively using new tools translates into increased productivity, decreased down time, and a host of other benefits for the entire organization.

One of the advantages of making such a transition is that it is often easy to get up to speed when using new tools, as is the case with Extended Events. Some tasks you may want to replicate from SQL Profiler, for example, are more easily executed with Extended Events. Ease of use is a huge benefit.

Datavail Can Help

What are you waiting for? Fix the issue before an obsolete technology becomes a problem that translates into productivity losses or causes your organization to be less than responsive to business needs.

Sometimes, it takes a little assistance and effort to transition to new tools and new ways of working. If you or your staff need more training or assistance with new tools, you may wish to contact Datavail. We can help you design custom tools and solutions, as well as assist with a wide range of other tasks to help your organization run more effectively and efficiently. By allowing our experts to tackle these tasks, we free your staff to focus on high-priority, high-value projects.

Be sure to read more on the topic with this webinar, titled “Extending Your Use of Extended Events.

If you would like to know more about our outsourcing services and how we can help, please contact Datavail to discuss a custom solution designed for your enterprise.

Image by elnur/123RF.

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

ORA-12154: TNS:could not resolve the connect identifier specified

Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link.

Jeremiah Wilton | March 4, 2009

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

12c Upgrade Bug with SQL Tuning Advisor

Learn the steps to take on your Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.