SQL Server 2005 takes longer time to cancel a query

Hot Topic

grouping over multiple datasets
Insert and Outer Left Join
Mass flat file loading
External program (C#) to call and modify variables of a SSIS package?
Bulk Insert Speed Problems
HOW TO DEPLOY A PROJECT TO REMOTE SERVER
connection error
DtsConnection -- Consuming DTS DataReader In Code w/ Parameters
Numerous (every 10 minutes) Event log entries
Which system tables hold SSIS pkg information

SQL Server

Access vs. SQL Server
Wishlist: MOST WANTED Tasks, Sources, Transformations, and Destinations?
Error in SQL Server Management Studio Express when Attach DB
How to get the Row Number per Distinct Records?
Problem to connect to Reporting Services 2005 from Enterprise Managment Studio
Problems Using Temporary Tables
Does SSIS have these features????
Secruity Question, putting SQL Server 2000 or 2005 on Windows Server 2003 running a website
Sql Express desktop app security
An incorrect or unsupported HTTP function call was made error

SQL Server 2005 takes longer time to cancel a query

Cancelling queries takes longer than it used to in SQL Server 2K

Dont know why ... Is it a new feature Big Smile


Answer this question

SQL Server 2005 takes longer time to cancel a query

  • MooMansun

    This might be extra code, can you log a bug in the feedback centre please

  • Matt.Lin

    I press the upper right X on the query window to close the query window where the query is executing.  It stops it immediately.  But, you are right, it takes A LOT longer now.  It's frustrating.



  • Kaveh E

    I too don't know and I am not sure if it takes longer or not.
    But, It would be nice to know if Yukon is performing additional set of processing to cancel queries. Do you have any stats to back your observations

    thanks,
    nitesh.ambastha@csfb.com

  • SQL Server 2005 takes longer time to cancel a query
Answer this question