Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Simple select * query and return the time it took to execute

Hello to all

I am trying to set up an application monitor that simply runs a {select * from XXX} query and returns the time it took to respond

Can anyone help me on how to configure it??

Best regards to all

Find more posts tagged with

Accepted answers

IIRC you might be able to just throw your whole query in there as normal and just rig it up so that column 1 is an integer, maybe something like

select 1, * from table

In the past I remembered that it would basically just ignore anything outside row1 column1 (stat) column2 (message)

All comments

Set up a SAM SQL User Experience Monitor, give it creds that can access the db, voila

SQL Server User Experience monitor

Hello and thanks for the reply

This is exactly what I have done until now, and I get error "Unable to convert query result", probably because the query returns a lot of rows and not a simple number

Is there a way to bypass it? I am not interested in the results, but only in the time that it took to execute

Thanks in advance

turn it into a count(*)?

Not good, it optimizes the query and it returns the result very quickly

Quick Links