Comments (3)
Okay, no, first, don't do that. This isn't what sp_BlitzCache is for.
Your input parameters say you're asking for TWO THOUSAND execution plans, filtered for just one database. That doesn't make any sense.
What's the business problem you're trying to solve, and I can steer you towards a better solution?
from sql-server-first-responder-kit.
from sql-server-first-responder-kit.
@rlfink sp_BlitzCache isn't a good fit for that, unfortunately.
Your best bet there would be something like SQL Server's built-in Audit functionality: https://learn.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine?view=sql-server-ver16
from sql-server-first-responder-kit.
Related Issues (20)
- sp_BlitzFirst.sql: Incorrect URL for Slow Data File Reads HOT 1
- sp_BlitzQueryStore: The "multiple plans" warning flags up even when you only have one plan. HOT 2
- sp_BlitzFirst: add @ExpertMode = 2 switch to skip sp_BlitzWho
- sp_BlitzFirst: "Garbage Collection in Progress" warning can be triggered by memory-optimized TempDB
- sp_BlitzFirst: add analysis of sys.dm_os_memory_clerks usage HOT 1
- sp_BlitzFirst: add warning about approaching max worker threads
- sp_BlitzFirst: plan cache results show up when they shouldn't
- sp_Blitz_who : transaction_isolation_level wrongly reported HOT 8
- Installing sp_DatabaseRestore produces a ton of warnings about CommandExecute
- Deprecating sp_AllNightLog, sp_BlitzInMemoryOLTP, and sp_BlitzQueryStore
- sp_BlitzFirst: better Azure SQL DB start time detection
- Missing entry in master.dbo.SqlServerVersions table HOT 1
- sp_BlitzFirst: Wait Stats Details does not display correct number of seconds that the server spent waiting HOT 4
- Inserted columns are incorrect (probably just swapped) in a couple of places HOT 1
- Name column from sys.schemas accessed using [NAME] rather than [name] HOT 1
- Database count does not exclude all databases that will be excluded HOT 1
- Can DB_NAME() ever return a different value to sys.databases.name? HOT 1
- Typos in the index script HOT 1
- DROP TABLE IF EXISTS is use, but Blitzindex should be compatibel with SQL Server 2014 and below HOT 1
- sp_BlitzIndex fails if you don't have permissions to query sys.sql_expression_dependencies
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sql-server-first-responder-kit.