March 1, 2005 at 8:27 pm
I am having problems with my SQL as i am using multiple threads to query the database. What is the maximum number of queries such that the SQL will perform smoothly and si there any way of increase the capabilities of SQL such that i increase the number of concurrent queries?
March 1, 2005 at 9:33 pm
Hai,
Are you trying to use multiple threads from any front end application.
Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me
March 1, 2005 at 10:41 pm
Yes, my application will be create mutiple threads and each thread will be quering the database
March 2, 2005 at 7:18 am
Concurencey of queries has a lot to do with hardware and design more than SQL's capabilities. You might try using Profiler to monitor the workload and use the Index tuning wizard with the load to see if there are any index changes that might help. Also look at the queries you run and wrap as many as possible in Stored Procedures might help. Look at your table structures you might find design issues there. But the key is find your worst performing queires and determine why they perform like they do.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply