Looking for a SQL Monitor I Think 2

[Rob7]

Hi All,
I am looking for a product that will monitor a SQL database and in some way, record the table and fields hit during an application transaction. For example, if I add a customer to a CRM package, what fields in which tables will get read, updated or possibly deleted during the transaction. Thanks in advance.

Rob

Cytec Corporation
rbrown@cyteccorp.com

 

[mrdenny]

Use SQL Profiler. it comes with SQL Server and should be available from the Start/Programs/Micorosft SQL Server menu.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Rob7]

Thanks Denny. I will run through this and see what I can find. Never knew it was there.

Rob

Cytec Corporation
rbrown@cyteccorp.com

 

[asmith1972]

we use SQL Stripes from

http://www.purenetworking.net

very easy to use and seams pretty reliable which is always good ;-)

 

[SQLSister]

This FAQ suggests some books on performance tuning:
Useful Reference Books for SQL Server Professionals faq183-3324

The last one will help you a lot with how to run Profiler. The link for where to get it is:

http://www.shareit.com/product.html...com/shop/itembycat.asp?catid=3&currencies=USD

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[Catadmin]

If there are specific tables you want to watch, check the <DBName>.SysObjects table. The ID column is the SPID (or ID) that you can specifically monitor in Profiler and allows you to exclude other non-essential Profiler hits.

This has helped me many times in the past. Also, database IDs can be gotten in a similar manner in the Master.SysDatabases table.

IMPORTANT NOTE: Make sure you only access these tables in read only mode or via a view or something harmless. If you pull everything up directly from the Enterprise Manager -> Database -> SysObjects table or Master -> SysDatabases table, and accidently type over something, you can kill your table/database.



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[mrdenny]

Catadmins note about only viewing the system tables is why you should use the INFORMATION_SCHEMA views instead of the system tables to get information like this. They are a nice read only way to get the info you need. Look up INFORMATION_SCHEMA in BOL for full syntax and a list of the views.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)