sql-performance, performance-tools,

How to Perform a SQL Server Query Tune on a Table Without Rows

Javier Javier   May 24, 2021 · 1 min read
How to Perform a SQL Server Query Tune on a Table Without Rows
Share this

Are you dealing with performance issues in a production environment? Sometimes we can found queries called behind a DMZ or PCI Environment.

Tuning these queries is not always a straightforward process.
I mean this because the SQL Server instance behind a DMZ or PCI environment in many scenarios can difficult to tune; it’s not easy to establish a connection from an uncontrolled environment.
Also, it’s not a good idea to open back-doors to the developers or DBA’s when we can get issues related to sensitive data like GDRP, HIPPA, PCI, etc.

What options do we have?

Let’s assume the following scenario:

  • We have a SQL Server instance behind a PCI environment, where we have sensitive financial data that only can be accessed from a limited list of servers.
  • We cannot install performance tools in these server boxes.
  • Per PCI compliance, we cannot restore the database in our development environment using the same data we had within the controlled environment.
  1. Tune the query
TOP 10 * 
FROM sys.dm_exec_request
Want More Learning and Tips
Keep learning with Us. Receive latest posts in your inbox!
Written by Javier Follow
Hi, I am Javier, a data professional, former baseball player, love to explore new ideas and I'm passionate to write. I hope you like this personal project life!