SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Application slow response when ssms is closed
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Olaf
Starting Member

3 Posts

Posted - 01/23/2013 :  03:41:11  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2011 Posts

Posted - 01/23/2013 :  08:17:10  Show Profile  Visit jackv's Homepage  Reply with Quote
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 - 01/23/2013 :  09:30:03  Show Profile  Reply with Quote
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 - 01/23/2013 :  10:16:17  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2011 Posts

Posted - 01/24/2013 :  13:29:03  Show Profile  Visit jackv's Homepage  Reply with Quote
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

India
15 Posts

Posted - 06/13/2013 :  02:03:00  Show Profile  Reply with Quote
Thanx Olaf Learnt something new TODAY






Neeraj Prasad

Tutorial Sql Server
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000