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.
- 0 Answers
- 2471 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is exporting utility?
Can you tell me some of the common replication dmv's and their use? : sql server replication
When we should use and scope of @@identity?
What is implicit mode in sql server?
What are entities and relationships?
How do I find query history in sql server?
how can we know that how many users are connected in perticuler server??????
How to write a query with an inner join in ms sql server?
What is a Lock and let me know Different types of locks?
Explain the first normal form(1nf)?
What is lock escalation?
What do you understand by triggers and mention the different types of it?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
