SQL Server Performance Forum – Threads Archive
Performance
I am developing some reports and have noticed the following behaviour. When I run the following query from Query Analyzer(SQL 2005), it takes approximately 3 mins. But when I run using ADO connection it will take ~15 mins. Do you have any suggestions that might explain this type of behaviour? Do I need to do any settings to the database to give remote connections equal priority or something like that? Note, I first noticed this behaviour on saturday. Prior to then, the remote connection was performing on par with calls from Query Analyzer.There is no priority setting in sql server to change this type of things..<br /><br />How many rows your query is returning?<br />It could be your network <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS†with no warranties for accuracy.<br />
Are you returing rowcount as well on that report?
http://sqlserver-qa.net/blogs/perft…-optimizer-reuses-for-better-performance.aspx
http://sqlserver-qa.net/blogs/perft…owcount-affects-the-performance-sql-2005.aspx
fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>