Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Views taking long to execute
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

102 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

Posting Yak Master

102 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

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  
 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.03 seconds. Powered By: Snitz Forums 2000