Error Log Part 2

I already discussed the steps of server starts which log info at error logs here, In this blog I would like to share the information we can get from error log.

Error Log  contains:

  1. Version of Sql server
  2. Version of  Windows
  3. Sql ServerPackage(Enterprise/standard…)
  4. How manu CPU are on the server.
  5. Sql server exe process ID
  6. What network library are used to listen for new connection
  7. state of database for as DLL (TDS)
  8. where any extended procedure executes
  9. What method was sql server shutdown(service system/t-sql)
  10. History of DSS and transaction log backup
  11. summary of DBCC CheckDB Execution.

There are many ways we can hide and show some extra information on error log by enabling/desabling respective trace( I will discuss it somewhere in my blog later).

Thanx.

Vinay

Advertisements
This entry was posted in Error Log, General and tagged , . Bookmark the permalink.

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s