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?
Sql-server – Verify Query Request Received
sql serversql-server-2005
Related Question
- Sql-server – Send data from SQL to a serial port or IP address
- Sql-server – sys.dm_exec_requests does not show short lived requests
- Sql-server – a query that shows the load request received through GPRS by salesman
- SQL Server Query Progress – Indicating Running Query Progress in SQL Server
- SQL Server Monthly Backup
- Sql-server – SA user password for software which automatically installs SQL Server 2005
- SQL Server 2005 – Track Write Requests on Read-Only Database
- Sql-server – Getting Only What Changed from SQL Server 2005
Best Answer
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.