hi,
the following are the outputs of sp_spaceused and
sp_tempdbspace
sp_spaceused
------------
database size unallocated size
tempdb 77752.95 MB 28026.99 MB
sp_tempdbspace
-------------
database size spaceused
tempdb 77752.945312 1.007812
the unused space in sp_spaceused is nearly 28 Gb and in
sp_tempdbspace is nearly 76 Gb
cany any one explain about this output and why its giving
different results.
- 1 Answers
- 3029 Views
- I also Faced
- E-Mail Answers
Answer Posted / Surendra Nath
The difference in results between sp_spaceused and sp_tempdbspace is due to the way these stored procedures report the allocated and unallocated space for the tempdb database. sp_spaceused provides a high-level overview of the total size, used space, and available space for all databases on the instance, whereas sp_tempdbspace focuses specifically on the tempdb database. The unused space in sp_spaceused is nearly 28 GB, while the unused space reported by sp_tempdbspace is nearly 76 GB, but this discrepancy is likely due to the different methods used for reporting and not actual lost space.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between upgrade and migration in sql server?
How to rebuild the master database?
How do I find query history in sql server?
Equi join and non equi join is possible with sql server?
What is the primary use of the model database?
What is in place upgrade in sql server?
How do I create a trace in sql server?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Explain “row_number()” in sql server with an example?
What are the kinds of subquery?
What is sql server query analyzer?
Can one drop a column from a table?
What are wait types?
What is a coalesce function?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
