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 2008 Forums
 Other SQL Server 2008 Topics
 Application slow response when ssms is closed

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

Posted - 2013-01-23 : 08:17:10
Is it just the first time AFTER the ssms closes where the app is slower or is it subsequent times?
Without commiting a trace or checking other indicators , it's difficult to know the source of the problem.
Read through a troublshooting guide on slow running queries - http://www.sqlserver-dba.com/2012/11/sql-server-how-to-troubleshoot-a-slow-running-query.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

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.
Go to Top of Page

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!
Go to Top of Page

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
Go to Top of Page

neeraj_sharma
Starting Member

15 Posts

Posted - 2013-06-13 : 02:03:00
Thanx Olaf Learnt something new TODAY






Neeraj Prasad

Tutorial Sql Server
Go to Top of Page
   

- Advertisement -