Skip to content

Database Consultant

Richard Brian Smith

Search for:

Categories

Azure
Docker
GCP
GDPR
HPOV
Log-Shipping
MDX
MongoDB
MS SQL 2000
MS SQL 2005
MS SQL 2008R2
MS SQL 2012
MS SQL 2014
MS SQL 2016
MS SQL 2017
MS SQL 2019
MySQL
Oracle
Oracle 11g
Oracle 9
Oracle Financials
PostgreSQL
Powershell
Reports
Spatial
SSRS
Uncategorized
UNIX
Windows

Meta

Register
Log in
Entries feed
Comments feed
WordPress.com

Improving sp_BlitzLock

I notice the output from sp_BlitzLock surfaces object_id’s in the query column.

It is a simple matter to decode object_id’s like …

SELECT OBJECT_NAME(SomeNumber);

… where SomeNumber is the object id.

Share this:

Twitter
Facebook

Like this:

Like Loading...

Posted on September 17, 2018September 17, 2018Author RichardCategories MS SQL 2008R2, MS SQL 2012, MS SQL 2014, MS SQL 2016

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

Notify me of new comments via email.

Notify me of new posts via email.

Δ

Post navigation

Previous Previous post: Reducing index count

Next Next post: Deadlocks from Entity Framework

Follow Following
- Database Consultant
- Already have a WordPress.com account? Log in now.

%d bloggers like this: