For the past few days we are facing problem in some of our
databases. The no of dead locks are increasing and when we
check the database size with SP_spaceused, the amount of
unallocated space is showing a negative value. Actually,
there is lot of unused space also. The database has been
configure to autogrow.
We are surprised to see the negative Un-allocated space as
normaly system should allocate new extents if the space is
not available. When we used sp_spaceused @.updateusage
= 'true', then the allocation is comming alright.
Any one who has faced the same problem may please share
how to solve this permanently.This is a known issue with sp_spaceused. Also look into using DBCC
UPDATEUSAGE.
Note, this may not be related to why you are seeing deadlocks.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Lokesh" <lokesh.raju@.moserbaer.net> wrote in message
news:07db01c35366$261732d0$a101280a@.phx.gbl...
For the past few days we are facing problem in some of our
databases. The no of dead locks are increasing and when we
check the database size with SP_spaceused, the amount of
unallocated space is showing a negative value. Actually,
there is lot of unused space also. The database has been
configure to autogrow.
We are surprised to see the negative Un-allocated space as
normaly system should allocate new extents if the space is
not available. When we used sp_spaceused @.updateusage
= 'true', then the allocation is comming alright.
Any one who has faced the same problem may please share
how to solve this permanently.|||I'd like to rely on taskpad view for quick examination of db size, or run my
customized stored proc or function to get the correct figures in real time
(use DBCC SHOWFILESIZE" and "DBCC SQLPERF(LOGSPACE)").
I do NOT need to run DBCC UPDATEUSAGE like I had to with sp_spaceused.
Richard
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:eonUPt2UDHA.1836@.TK2MSFTNGP09.phx.gbl...
> This is a known issue with sp_spaceused. Also look into using DBCC
> UPDATEUSAGE.
> Note, this may not be related to why you are seeing deadlocks.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> What hardware is your SQL Server running on?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Lokesh" <lokesh.raju@.moserbaer.net> wrote in message
> news:07db01c35366$261732d0$a101280a@.phx.gbl...
> For the past few days we are facing problem in some of our
> databases. The no of dead locks are increasing and when we
> check the database size with SP_spaceused, the amount of
> unallocated space is showing a negative value. Actually,
> there is lot of unused space also. The database has been
> configure to autogrow.
> We are surprised to see the negative Un-allocated space as
> normaly system should allocate new extents if the space is
> not available. When we used sp_spaceused @.updateusage
> = 'true', then the allocation is comming alright.
> Any one who has faced the same problem may please share
> how to solve this permanently.
>
>|||If you want to rely on the GUI, then run DBCC UPDATEUSAGE on a regular basis
(like as part of stats update or index defrag jobs would be good) and run it
after any major changes (like copying in or out a bunch of data, or if the
thing gets full)
"Richard Ding" <dingr@.cleanharbors.com> wrote in message
news:%23g91osFVDHA.2068@.TK2MSFTNGP11.phx.gbl...
> I'd like to rely on taskpad view for quick examination of db size, or run
my
> customized stored proc or function to get the correct figures in real time
> (use DBCC SHOWFILESIZE" and "DBCC SQLPERF(LOGSPACE)").
> I do NOT need to run DBCC UPDATEUSAGE like I had to with sp_spaceused.
>
> Richard
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:eonUPt2UDHA.1836@.TK2MSFTNGP09.phx.gbl...
> > This is a known issue with sp_spaceused. Also look into using DBCC
> > UPDATEUSAGE.
> >
> > Note, this may not be related to why you are seeing deadlocks.
> >
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > What hardware is your SQL Server running on?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> >
> >
> > "Lokesh" <lokesh.raju@.moserbaer.net> wrote in message
> > news:07db01c35366$261732d0$a101280a@.phx.gbl...
> > For the past few days we are facing problem in some of our
> > databases. The no of dead locks are increasing and when we
> > check the database size with SP_spaceused, the amount of
> > unallocated space is showing a negative value. Actually,
> > there is lot of unused space also. The database has been
> > configure to autogrow.
> >
> > We are surprised to see the negative Un-allocated space as
> > normaly system should allocate new extents if the space is
> > not available. When we used sp_spaceused @.updateusage
> > = 'true', then the allocation is comming alright.
> >
> > Any one who has faced the same problem may please share
> > how to solve this permanently.
> >
> >
> >
> >
>
订阅:
博文评论 (Atom)
1 条评论:
Did you know that that you can generate dollars by locking premium pages of your blog / website?
All you need to do is join AdscendMedia and run their Content Locking tool.
发表评论