July 30, 2007 at 2:33 am
Hi,
We have a higher end database server that is accessed by the users using front end developed in Visual Basic 6.0. Also there is an application developed in .Net accessing another two databases from the same server.
Sometimes users accessing the database throguh Desktop application get an error timeout expired. The application is basically a query builder that builds and executes the queries for end users. User gets the error approx. 3-4 times and in next attempt they get the output.
I checked for any deadlock but could not find any. What else can I check to confirm that the database server / database is responding properly?
Thanks in advance.
Regards,
Rohit
July 30, 2007 at 3:26 am
Have a look at the audit section of http://www.sql-server-performance.com/articles/audit/main.aspx
The timeout can come from "normal" locks on records (applications fetching not all or too many data), I/O throughput.
Are these readonly queries or readwrite?
July 30, 2007 at 4:09 am
Thanks for your reply. These are readonly queries. Recordsets opened with Client side cursors.
July 30, 2007 at 11:03 am
If you have sysadmin rights, you could start a trace with sqlprofiler to see the troublesome queries.
sp_who2 gives the current connections and if it is blocked (temporarily) by another.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply