Solved

a simple query in a while loop to check SQL Server response

Posted on 2014-10-07
2
150 Views
Last Modified: 2014-10-08
could you recommend/suggest  a simple SQL statement that can be run every minute or 3 or so, to bring a response and how many [ms] it took to bring it back.. just to get an idea of the response time.. that will give some idea that the system is  not over-whelmed..
 
 thanks
0
Comment
Question by:25112
2 Comments
 
LVL 26

Assisted Solution

by:Zberteoc
Zberteoc earned 250 total points
ID: 40367104
Basically from a simple app you connect to a SQL server and then execute:

SELECT 1

if you capture the time before you send the request and the time after the request came back and make a difference you will have your answer.
0
 
LVL 49

Accepted Solution

by:
Vitor Montalvão earned 250 total points
ID: 40367735
SELECT GETDATE() returns the current date and time on the server but it's not like that that you verify for bottlenecks in SQL Server,
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
tempdb log keep growing 7 44
sql query 5 44
SQL Syntax 6 30
Not listening to where 1 18
Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question