<div>
From BOL regarding running updateusage:<br />
<br />
&quot;Use it only when you suspect incorrect values are being returned and when the process will not have an adverse effect on other users or processes in the database. If preferred, DBCC UPDATEUSAGE can be run separately.&quot;<br />
<br />
1) What are the &quot;&nbsp;adverse effect on other users or processes in the database&quot; when running DBCC UPDATEUSAGE?<br />
<br />
2) Is it only a performance issue?<br />
<br />
2) Any issue with the actual data?<br />
<br />

</div>


From BOL regarding running updateusage:

"Use it only when you suspect incorrect values are being returned and when the process will not have an adverse effect on other users or processes in the database. If preferred, DBCC UPDATEUSAGE can be run separately."

1) What are the " adverse effect on other users or processes in the database" when running DBCC UPDATEUSAGE?

2) Is it only a performance issue?

2) Any issue with the actual data?



<div>
The -ve value returned by sp_SpaceUsed may be, because of the operations such asl arge delete/update on the tables or dropping of indexes. In such a situations information in the sysindexes tables may not be updated. .<br />
<br />
&gt;1) What are the &quot;&nbsp;adverse effect on other users or processes in the database&quot; when running DBCC UPDATEUSAGE?<br />
DBCC Commands take lot of IO and CPU Resources, So Make sure that the CPU is not busy, and you have enough space left in tempDB<br />

</div>


The -ve value returned by sp_SpaceUsed may be, because of the operations such asl arge delete/update on the tables or dropping of indexes. In such a situations information in the sysindexes tables may not be updated. .

>1) What are the " adverse effect on other users or processes in the database" when running DBCC UPDATEUSAGE?
DBCC Commands take lot of IO and CPU Resources, So Make sure that the CPU is not busy, and you have enough space left in tempDB


<div>
<div class="content wysiwyg-content">
<br />
I’ve run sp_spaceused against a table and I got as unused space the value of – (minus) 8KB, which is the size of a data page.<br />
<br />
I’ve checked the filegroup that this table belongs to and there is free space for that filegroup.<br />
<br />
How come this negative value? <br />
<br />
Do I have to do something? <br />
<br />
Thank you,<br />
Deepak<br />

</div>
</div>



I’ve run sp_spaceused against a table and I got as unused space the value of – (minus) 8KB, which is the size of a data page.

I’ve checked the filegroup that this table belongs to and there is free space for that filegroup.

How come this negative value? 

Do I have to do something? 

Thank you,
Deepak


negative value when I run sp_spaceused

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.