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
 General SQL Server Forums
 New to SQL Server Administration
 Views taking long to execute
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Vishal_sql
Posting Yak Master

101 Posts

Posted - 10/08/2012 :  03:28:46  Show Profile  Reply with Quote
Hi All,

I am working on SQL Server DB,and it is accessed by the PMO/PM through the views created on portal environment(portal means :- where the PM/PMO could run the views)

For few reports, the view is taking so long time to run.

As a Database developer How can i know what is causing the DB slower.

Any help would be highly appreciated
Thanks.

Vishal_sql
Posting Yak Master

101 Posts

Posted - 10/08/2012 :  03:50:01  Show Profile  Reply with Quote

I meant "the view is taking so long time to run."

Some time it takes very long while some time it runs as expected in few seconds.

Does the instances opened in Db causes the queries to run slow?
I checked it by

exec master.dbo.sp_lock

which has most of the sleeping,runnable,dormant.

Go to Top of Page

NeilG
Aged Yak Warrior

United Kingdom
530 Posts

Posted - 10/12/2012 :  03:51:51  Show Profile  Reply with Quote
What version of SQL Server are your working on, also look up DMV's and DMF's things like sys.dm_exec_query_stats can give you an idea of which queries are taking the longest.

Also look to see if there are indexes on the base tables
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.05 seconds. Powered By: Snitz Forums 2000