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.
| Author |
Topic |
|
Olaf
Starting Member
3 Posts |
 Posted - 2013-01-23 : 03:41:11
|
| I have an application wich runs with a very slow response time.De sql server is on the same pc as the application.The application has a fast response when I open the ssms and a table from the database. (The table has nothing to do with the querys I am running. Closing down the opened table makes my application slow again. The speed is 40 times slower!!Please help me |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
Olaf
Starting Member
3 Posts |
Posted - 2013-01-23 : 09:30:03
|
| The application is always slow!The application is in one case fast. When ssms is open and opened a table. When ssms is closed again it is slow again. |
 |
|
|
Olaf
Starting Member
3 Posts |
Posted - 2013-01-23 : 10:16:17
|
| Found the solution!!The application needed to start up the database. With the option/auto close =false, was the problem solved! |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-01-24 : 13:29:03
|
| Is SSMS the front end of the application?What does this do"option/auto close =false" ?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
neeraj_sharma
Starting Member
15 Posts |
Posted - 2013-06-13 : 02:03:00
|
Thanx Olaf Learnt something new TODAY  Neeraj Prasad Tutorial Sql Server |
|
|
|
|
|
|
Application slow response when ssms is closed