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
 General SQL Server Forums
 New to SQL Server Administration
 Application slow

Author  Topic 

viswesh
Starting Member

2 Posts

Posted - 2012-10-12 : 02:42:27
Hi Guys,

I have deployed a msssql server, only five DB's are configured in that. One DB is configured for a application, but the application is tremendously slow, but when a query is executed in the MSSql server, its fast. We have already checked the application, there is no issue with that. Please help me, what could be the reason?
1) I have checked that application has established 7 connections with the DB

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-10-12 : 03:11:29
Run a trace to grab the execution plan and compare it with the execution plan that you get in SSMS. If you see any difference, it needs to be investigated. There could be conversions occurring or connection settings that significantly impact performance.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

viswesh
Starting Member

2 Posts

Posted - 2012-10-12 : 05:00:52
Can you explain in more details? what else could be the problem?
Go to Top of Page
   

- Advertisement -