Tags » SQL Performance

How to Detect Slow Queries with jOOQ

Just now, we implemented a nice little feature in jOOQ’s code generator:
https://github.com/jOOQ/jOOQ/issues/4974

It detects whenever the jOOQ code generator runs a slow query to reverse engineer schema meta information. 860 more words

Sql

SQL SERVER - Performance counter missing! DMV sys.dm_os_performance_counters is Empty

The topic around performance tuning is the most sought out search on this blog. Almost every single day the top search that lands here are around performance or around some random errors one might receive from the application. 407 more words

SQL Authority

SQL SERVER - Monitoring and Troubleshooting SQL Server Got Easy with Diagnostics Tool

Blogging has never been an easy task. With close to 9 years of non-stop learning and sharing has got me into a rhythm that I rarely miss a single day without writing one. 1,108 more words

SQL Authority

Interview Question of the Week #051 - Actual Execution Plan vs. Estimated Execution Plan

In one of the recent interview, I met quite a few interesting candidates. It is common for employees ask many questions during an interview, but there are times when candidates also ask questions back to the interviewee. 100 more words

SQL Authority

SQL SERVER 2016 - Comparing Execution Plans

New tools bring new capabilities and sometimes these are ingrained deep into the product that we can easily miss them out. And SQL Server 2016 is no different. 387 more words

SQL Authority

How to Optimize SQL Select Statements

The value of a website can be placed on the SQL Server performance. If the SQL Server isn’t able to produce results in a reasonable amount of time, the website visitors lose patience and move on to another domain. 416 more words

Database Programming

SQL SERVER - Save and Send Execution Plan Via Email

Here is an interesting question, I received the other day.

Hi Pinal,

I have a very big graphical execution plan and I want to send it to my friend. 283 more words

SQL Authority