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.
| Author |
Topic |
|
Vishal_sql
Posting Yak Master
102 Posts |
 Posted - 2012-10-08 : 03:28:46
|
| 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
102 Posts |
Posted - 2012-10-08 : 03:50:01
|
| 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_lockwhich has most of the sleeping,runnable,dormant. |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2012-10-12 : 03:51:51
|
| 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 |
|
|
|
|
|
|
Views taking long to execute