Slow SQL

[EscapeUK]

My VB which looks at a SQL DB has started to run very slowley.

Any ideas of what I can look at?

 

[foxdev]

You're going to have to provide a lot more details. What, specifically, is running slowly?

Try running the SQL Server Profiler (available from your Windows SQL Server program group) and run the Wizard for "slowest running queries"; when you identify which operations are taking unusually long, post the statement here (the statement will appear in the Profiler output). Robert Bradley

http://www.foxdev.com/

Do you have too much money? Visit

http://www.agrainofhope.org

 

[EscapeUK]

Well we have a VB app that has strated to run very slowley. It uses MTS, I have a bit of knowledge of SQL but not much.