Deadlock

Hi All,
I need help urgently.
I got problem.
Whenever I issue DBCC SHRINKDATABASE the below message appear.
Server: Msg 1205, Level 13, State 57, Line 1
Transaction (Process ID 65) was deadlocked on lock resources with
another process and has been chosen as the deadlock victim. Rerun the
transaction.
I've tried to find out log transation by issue some command
sp_who,sp_who2,sp_lock,
SELECT spid, blocked, waittime
FROM sysprocesses
WHERE blocked <> 0
AND waittime > 10000
ORDER by waittime DESC
...
Yet It doesn't help me.
I found no deadlock process.
Could help me please?
Thanks, in advace, for helping me..
Regards,
Lux
*** Sent via Developersdex http://www.codecomments.com ***It's known to happen sometimes. How to address it depends on
a few things. First, are you sure you actually need to
execute a shrink operation? Sometimes people start running
those and they really aren't necessary. Make sure you are
backing up your log as needed. You should check the
following article for more information:
http://www.karaszi.com/sqlserver/info_dont_shrink.asp
Also, if you really do need to do a shrink, try using dbcc
shrinkfile instead of shrinkdatabase so you have more
control over what files are being shrunk to what size. And
then if you are trying to shrink the data file...you may
want to try executing a DBCC INDEXDEFRAG which could help
when you then run a shrinkfile.
-Sue
On Mon, 22 Aug 2005 02:36:43 -0700, lux sok
<lux.lyny@.gmail.com> wrote:

>Hi All,
>I need help urgently.
>I got problem.
>Whenever I issue DBCC SHRINKDATABASE the below message appear.
>Server: Msg 1205, Level 13, State 57, Line 1
>Transaction (Process ID 65) was deadlocked on lock resources with
>another process and has been chosen as the deadlock victim. Rerun the
>transaction.
>I've tried to find out log transation by issue some command
>sp_who,sp_who2,sp_lock,
>SELECT spid, blocked, waittime
>FROM sysprocesses
>WHERE blocked <> 0
>AND waittime > 10000
>ORDER by waittime DESC
>...
>Yet It doesn't help me.
>I found no deadlock process.
>Could help me please?
>Thanks, in advace, for helping me..
>Regards,
>Lux
>
>*** Sent via Developersdex http://www.codecomments.com ***|||Thanks, in advance, for helping me.
By the way, If i don't issue command DBCC SHRINKDATABASE/FILE do we have
any way to solve a logical file size grow ?
I mean when I droped/truncated a table the space remain the same
(logical file size).
For example, a table eat up 72GB when i dropped it.
I still can get this space back.
So my hard drive will full.
Any idea or comment please.
Maybe i'm not sure about the behind structure of MS SQLSERVER.
Thanks,
*** Sent via Developersdex http://www.codecomments.com ***|||That should be a one time thing then right? You would use a
dbcc shrinkfile for that specifying the data file - that's
the file you are concerned about correct? The MDF?
Did you try dbcc shrinkfile?
If you get deadlocks, try the indexdefrag and then the
shrinkfile.
-Sue
On Tue, 23 Aug 2005 01:19:26 -0700, lux sok
<lux.lyny@.gmail.com> wrote:

>Thanks, in advance, for helping me.
>By the way, If i don't issue command DBCC SHRINKDATABASE/FILE do we have
>any way to solve a logical file size grow ?
>I mean when I droped/truncated a table the space remain the same
>(logical file size).
>For example, a table eat up 72GB when i dropped it.
>I still can get this space back.
>So my hard drive will full.
>Any idea or comment please.
>Maybe i'm not sure about the behind structure of MS SQLSERVER.
>Thanks,
>
>*** Sent via Developersdex http://www.codecomments.com ***