I am currently using SQL Server 2008. I have a problem with DTA. Here are my steps:
I created a new session to analyze my request.
I canceled the process because it took so long (1 hour / request). At that time, when I canceled, this process was at the 4th step (report generation).
I closed the session.
I tried to delete the session, but DTA did not allow me to delete. he said he was interrupted in the status toolbar. I understood this suggestion, but I was waiting to delete this session within 6 hours. I do not understand why this has been interrupted for so long. This is just one small request.
Can anybody help me?
Thank.
Edit: The solution is to first remove the connection that connects to the database. It. Thank.