Event Table in SQL Azure / sys.event_log

Stumbled across this excellent Teched Preso on SQL Admin and Self Servicing and was

Technorati Tags: ,

intrigued about the Event Table feature that records connection issues / timeouts etc. Found it has been implemented by new portal @ by :

  1. From manage.windowsazure.com , clicking on SQL Databases on left then Manage or go straight to https://<yourinstancename>.database.windows.net
  2. Type in your SQL Admin credentials , leave Database blank
  3. Click on Administration bottom left
  4. And then Events . You get a nice graph like below which is aggregated by day

To see more granular detail , connect to master database in Management Studio and do

SELECT * FROM sys.event_log

Quite useful as had some weird stuff happen on web site and think it may have been down to idle connection timeouts

eventinfotrim

About these ads

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