Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Must have Management Studio open

Author  Topic 

kouick
Starting Member

2 Posts

Posted - 2014-10-28 : 08:37:13
Hi,


Here is my problem: i have an application which uses as engine SQL 2012. The response times are very slow. But if i open a window of query on SQL Management Studio, the response times are very fast.

Would you have an idea on why ?

Kouick.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-10-28 : 08:57:59
You haven't given nearly enough information to give a definitive answer, but I'd say the problem is the application.
Go to Top of Page

kouick
Starting Member

2 Posts

Posted - 2014-10-28 : 09:17:06
I have the solution.

In my database, the option "Auto_close" was on "True". I change it to "False" and i have de great result.
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-10-28 : 09:38:32
makes sense
Go to Top of Page
   

- Advertisement -