Using FN_DBLOG function to interpret a SQL Server file

by:
Greg Low

FN_DBLOG is a function undocumented by Microsoft. Get the resources to utilize FN_DBLOG in interpreting an LDF file.

This Article Covers

Stored Procedures

Looking for something else?

+ Show More

Can you tell me how to interpret information in an LDF file using this command:

FN_DBLOG( , )

Step 2 of 2:

Safe Harbor

FN_DBLOG is an undocumented function. For an example of its use, Greg Linwood posted some info recently in his "Transaction blog: Using ::fn_dblog() to identify which indexes are experiencing page splits."

This was first published in September 2007

Dig deeper on SQL Server Stored Procedures

All
News
Get Started
Manage
Problem Solve

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

E-Handbook

Developments in SQL Server BI point to focus on self-service, users

Related Q&A; from Greg Low

SQL Server id permission to create and modify tables

A SQL Server application that needs user permission to create and modify tables in SQL Server 2005 may be handled best via a schema.continue reading

Problem attaching stored procedure and SQL Server trigger

Learn why using the sp_OACreate stored procedure with a SQL Server 2005 trigger, is likely to result in a permissions problem.continue reading

Query to find SQL Server database names created by users

Find how to query in SQL Server to get all database names created by users.continue reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Hadoop 2, YARN set to shake up data management and analytics

Consultant Wayne Eckerson says Hadoop 2, with its key YARN component, qualifies as a flexible big data operating system. And it ...

Predictive analytics capabilities allow for top-notch big data modeling

Building effective analytical models is a key facet of big data analytics applications -- though doing so is easier said than ...

Spark is latest hyped-up big data framework

Spark has been getting a lot of attention lately, but is the big data framework ready for enterprise use?

SearchDataCenter

Does data center size matter in virtualization, DCIM decisions?

Are you big enough to take advantage of DCIM or virtualization for the power and cost savings? When it comes to certain moves, ...

Reap the benefits of private cloud, gradually

Many corporations are switching to a private cloud, which doesn't have to be a dramatic transition. Follow these tips to an easy ...

Hold on loosely: Data center outsourcing in the modern age

Wholesale colocation solutions often provide organizations with a number of financial and logistical benefits. But data center ...

SearchDataManagement

Tibco upgrades LogLogic to support faster log data analytics

Tibco has updated its LogLogic software that's used to manage log data collected from operational applications, integrating the ...

Design agility marks MongoDB enterprise use cases

NoSQL database MongoDB supports flexible schemas and agile development, several enterprise IT leaders told recent conference ...

Is a second machine age on the way, driven by big data?

MIT's Erik Brynjolfsson and Andrew McAfee see elements that may betoken another machine age, including big data and advances in ...

SearchAWS

AWS adds logs to CloudWatch, under-prices third-party tools

Amazon Web Service’s new CloudWatch Logs may give IT pros reason to ditch more expensive third party tools such as Splunk, Loggly...

AWS mobility swings for the fences, only gets to first base

Not to be outdone by mobile app giants like Google, AWS laid out several mobile features this week.

Combat a common error with AWS EC2 instances

RequestLimitExceeded is a common EC2 error that occurs when you make too many calls to AWS instances. But how many are too many?

SearchOracle

Q4 drops Oracle stock, but cloud may be silver lining

In recent Oracle news, the Q4 report drops Oracle stock, but Ellison more focused on cloud gains. Oracle released new Virtual ...

Data in Micros' point-of-sale systems may be alluring to Oracle

Micros Systems sells POS software to major retailers, restaurants and hotels. Why is Oracle interested in that? Maybe, it's about...

No normalization unexpected In-Memory option top feature

Oracle Database In-Memory option beta tester didn't go for Ellison's big-ticket items. He calls freedom from normalization the ...

SearchContentManagement

Is the right to be forgotten a disaster for the Web?

The right to be forgotten law in Europe could undercut the open exchange of information on the Web. Join our tweet jam August 7 ...

New tool aims to round out customer identity for marketers

This content management news roundup features a social media management platform that joins customers' Facebook identities to ...

Dell's chief data officer on building a data-driven culture

How do you democratize data analytics without creating chaos? Dell's chief data officer, Rob Schmidt, discusses the building ...

SearchWindowsServer

Microsoft cloud storage may lift Azure skyward

Microsoft will continue to blare its Azure cloud next week with several cloud storage announcements. Will users listen this time?

Internet Explorer, Windows Server Service Bus receive patches

In July's Patch Tuesday update, Microsoft issued critical fixes for Internet Explorer and a lesser-known Windows program.

Two new SCCM add-ons for advanced IT management

Microsoft System Center Configuration Manager tools fit the bill for small shops, but enterprises may have to spring for ...

Looking for something else?

Dig deeper on SQL Server Stored Procedures

E-Handbook

Related Q&A; from Greg Low

Have a question for an expert?

0 comments

E-Mail

Username / Password

Password

Forgot Password?

Your password has been sent to: