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 |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2010-04-12 : 11:00:22
|
| Team,in one of my production server for a DB we are facing performance problems as users are complaining about slow response time. |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-04-12 : 11:08:10
|
You know -- it's not good form to expose your clients like this:OBJECT:(<GLOBAL BRAND COMPANY NAME>.[dbo].[sysobjects]....... You might want to edit your post.You've got a table scan there also.Have you isolated any suspicious jobs? Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Performance issue