SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:33 PM
| ||||
| ||||
 SP_Lock Help I am wanting to learn how to diagnose locking problems on a query by looking at locking data in SP_Lock and not SQL Profiler. Books on line describes what each column means, but I would like an example to know what actions to take if I find 2 SPIDs competing for resources. For example, should I kill one or the other or do something else altogether. Help appreciated. Thanks. Frank *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!      |
|
02-28-2008, 06:33 PM
| ||||
| ||||
| Re: SP_Lock Help Frank Py <fpy@proactnet.com> wrote in message news:<3f9e8e14$0$197$75868355@news.frii.net>... > I am wanting to learn how to diagnose locking problems on a query by > looking at locking data in SP_Lock and not SQL Profiler. Books on line > describes what each column means, but I would like an example to know > what actions to take if I find 2 SPIDs competing for resources. For > example, should I kill one or the other or do something else altogether. > > Help appreciated. Thanks. > Frank > > > > *** Sent via Developersdex http://www.developersdex.com *** > Don't just participate in USENET...get rewarded for it! You can tell which users are concerned from the loginame and hostname field. Call them ask what they are doing and then you could have permission to kill their sessions.Sometimes the tables with frequent locks are almost always indexed poorly or the indexes need rebuilt.In my case sometimes the tables have had a couple of million rows and this helped the users delete some of the rows HTH Vince |
 |
« SQL Server questions???
|
Set variable based on result of procedure OR update columns fromsproc result »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:10 AM.
