Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a software system which queries data via OLEDB from an external SQL Server 2005. The query request is sent every 15 minutes. I want to verify that the SQL Server is receiving the query requests. How can I?

share|improve this question

1 Answer 1

Create a SQL Trace (server-side) and capture the SQL:StmtCompleted event. You can filter on the TextData column to ensure you're only getting the query that you are looking to ensure is happening.

The easiest way to create a server-side trace would be to create it in SQL Server Profiler (which is innately a client-side trace), do a quick start and stop and script out the trace definition and run it in SSMS. Please see this TechNet reference on Server-Side Tracing and Collection for an exhaustive reference on the details how to do this.

share|improve this answer
    
Thanks for the response, but I only want to know if the request is received. Could the request be received and not completed? –  vic May 30 '13 at 17:00
    
Sure. Monitor the SQL:StmtStarting event then. –  Thomas Stringer May 30 '13 at 17:31

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.