In this blog you will find various tools and articles that are useful to any DBAs. I will try to put more practical articles while at the same time post any database software bugs and some important tips on internals of sql server and optimization. Address cons and pros of different relational database management in use and new developments. This blog will also cover the market perception of different database system including some hard facts, reviews and benchmarks. Teshome Asfaw
Tuesday, April 24, 2012
Cannot shrink tempdb
How to shrink tempDB
SELECT * FROM sys.dm_exec_requests WHERE database_id = 2
select * from sys.dm_tran_locks
where resource_database_id= 2
select * from sys.dm_db_session_space_usage
where user_objects_alloc_page_count<> 0
SELECT * FROM sys.all_objects
where is_ms_shipped = 0
DBCC FREEPROCCACHE
BCC SHRINKFILE ('tempdev', 1024)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment