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 |
|
amurark
Yak Posting Veteran
55 Posts |
 Posted - 2011-09-09 : 12:05:36
|
| please tell me why blocking of database is thre while runnning the crystal report suddenly?PReviously also i ran same reports but no error was there but now why tell sudddenly ?????pls help me'Ankita |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-09-09 : 12:08:49
|
| Can you post the error messages you are seeing? Not clear what you meant by "blocking the database". It is possible that if the queries are resource intensive, the database can appear non-responsive. There could be other reasons, for example, if the underlying data has changed substantially, or if the statistics have not been updated etc. |
 |
|
|
amurark
Yak Posting Veteran
55 Posts |
Posted - 2011-09-09 : 12:14:27
|
| ID BlockingSPID DatabaseName Duration (Min) BlockingStatement Progaram Name Login Name LoginTime LastBatch HostName RowNo LevelRow [CPUTime] [Physical_IO]114 0 SM7 19 SELECT "PROBSUMMARYM1"."NUMBER", "PROBSUMMARYM1"."OPEN_TIME", "PROBSUMMARYM1"."SUBCATEGORY", "PROBSUMMARYM1"."ASSIGNMENT", "PROBSUMMARYM1"."PROBLEM_STATUS", "CONTCTSM1"."FULL_NAME", "PROBSUMMARYM2"."ZCIRCLE", "PROBSUMMARYM1"."CONTACT_PHONE", "PROBSUMMARYM1"."CONTACT_LOCATION", "PROBSUMMARYM1"."OPENED_BY", "PROBSUMMARYM1"."PRIORITY_CODE", "PROBSUMMARYM2"."LAST_UPDATE", "PROBSUMMARYM1"."RESOLVED_TIME", "PROBSUMMARYM1"."CLOSE_TIME", "PROBSUMMARYM1"."UPDATE_TIME", "PROBSUMMARYM1"."INCIDENT_ID", "PROBSUMMARYM1"."UPDATED_BY", "PROBSUMMARYM1"."ASSIGNEE_NAME", "PROBSUMMARYM1"."PRODUCT_TYPE", "PROBSUMMARYM1"."PROBLEM_TYPE", "PROBSUMMARYM2"."CALL_LOGGING_MODE", "PROBSUMMARYM1"."CLOSED_BY", "PROBSUMMARYM1"."RESOLVED_BY", "PROBSUMMARYM1"."RESOLUTION", "PROBSUMMARYM1"."ACTION" FROM ("SM7"."dbo"."PROBSUMMARYM1" "PROBSUMMARYM1" INNER JOIN "SM7"."dbo"."PROBSUMMARYM2" "PROBSUMMARYM2" ON "PROBSUMMARYM1"."NUMBER"="PROBSUMMARYM2"."NUMBER") INNER JOIN "SM7"."dbo"."CONTCTSM1" "CONTCTSM1" ON "PROBSUMMARYM1"."CONTACT_NAME"="CONTCTSM1"."CONTACT_NAME" WHERE NOT ("CONTCTSM1"."FULL_NAME"='Jennifer Falcon' OR "CONTCTSM1"."FULL_NAME"='Test User' OR "CONTCTSM1"."FULL_NAME"='TEST USER UNITECH' OR "CONTCTSM1"."FULL_NAME"='Test09 Test09') AND NOT ("PROBSUMMARYM1"."OPENED_BY"='Jennifer Falcon' OR "PROBSUMMARYM1"."OPENED_BY"='Sachin Nehra' OR "PROBSUMMARYM1"."OPENED_BY"='Soniya Gupta' OR "PROBSUMMARYM1"."OPENED_BY"='Test User' OR "PROBSUMMARYM1"."OPENED_BY"='TEST USER UNITECH' OR "PROBSUMMARYM1"."OPENED_BY"='Test09 Test09') Crystal Reports report Sep 9 2011 7:36AM Sep 9 2011 7:36AM GGN_DT_C800406 1 0 1079 0102 114 SM7 19 (@P1 datetime,@P2 varchar(51),@P3 datetime,@P4 varchar(51),@P5 varchar(51),@P6 varchar(41),@P7 varchar(51),@P8 datetime,@P9 varchar(51),@P10 float,Ankita |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-09 : 14:13:23
|
| are you doing some intensive write operations on a object? to get an idea of locks placed by process you can try runningsp_lock <process_id>this will give you details of locks placed on various objects by process------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
blocking of database