Comments (2)
I'm glad you did this because I've actually wondered in the past, "Are we gathering the data for every mode, every time?" and not gone into the code to look. Doh!
from sql-server-first-responder-kit.
@BrentOzar Yeah, looking through all the code, I was surprised at how many checks were completely unrelated. The only one I'm not entirely sure of is ForeignKeys. IndexSanity gets updated using that table, so I left it alone for now.
from sql-server-first-responder-kit.
Related Issues (20)
- 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
- sp_BlitzLock - Add the ability to filter to a specific type of deadlock
- sp_Blitz: Add more Query Store best practice checks. HOT 2
- sp_BlitzIndex has dependency on depricated procedure sp_BlitzInMemoryOLTP HOT 1
- README.md: sp_AllNightLog is still in the table of contents HOT 2
- sp_DatabaseRestore: Add param to enable service broker on restore
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.