Skip to main content
Database Administrators

Return to Question

added [performance-tuning] to 516 questions - Shog9 (Id=1924)
Link
Community Bot
Community Bot
  • 1
added 89 characters in body; edited tags; edited title
Source Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 423
  • 663

Associate SQL Server Associated Queries towith Databases

Is there a way via TSQLT-SQL and DMVs to show which database a query was run against? I do not want to use trace, profiler or extended events if I can help it. The

The goal is to look at CPU and I/O by query by database so I can redistribute the databases as I reconfigure the environment.

Thanks!I do not want to use trace, profiler or extended events if I can help it. I also do not want to shred XML if I can avoid it. I am looking for history not just active.

SQL Server Associated Queries to Databases

Is there a way via TSQL and DMVs to show which database a query was run against? I do not want to use trace, profiler or extended events if I can help it. The goal is to look at CPU and I/O by query by database so I can redistribute the databases as I reconfigure the environment.

Thanks!

Associate SQL Server Queries with Databases

Is there a way via T-SQL and DMVs to show which database a query was run against?

The goal is to look at CPU and I/O by query by database so I can redistribute the databases as I reconfigure the environment.

I do not want to use trace, profiler or extended events if I can help it. I also do not want to shred XML if I can avoid it. I am looking for history not just active.

Source Link
pshore73
pshore73
  • 427
  • 3
  • 9

SQL Server Associated Queries to Databases

Is there a way via TSQL and DMVs to show which database a query was run against? I do not want to use trace, profiler or extended events if I can help it. The goal is to look at CPU and I/O by query by database so I can redistribute the databases as I reconfigure the environment.

Thanks!