Инструменты пользователя

Инструменты сайта


software:windows:base_tempdb_too_big

Усечение базы TempDB

DBCC FREEPROCCACHE -- clean cache
DBCC DROPCLEANBUFFERS -- clean buffers
DBCC FREESYSTEMCACHE ('ALL') -- clean system cache
DBCC FREESESSIONCACHE -- clean session cache
DBCC SHRINKDATABASE(tempdb, 10); -- shrink tempdb
dbcc shrinkfile ('tempdev') -- shrink db file
dbcc shrinkfile ('templog') -- shrink log file
GO

-- report the new file sizes
SELECT name, size
FROM sys.master_files
WHERE database_id = DB_ID(N'tempdb');
Go

Далее, в свойствах базы задать InitialSize гораздо меньший, чем установлен (я задавал несколько раз подряд 1024Мб).

TAG: {{tag>sysadmin MSSQL TempDB}

Обсуждение

, https://fastpriligy.top/, d.m.Y H:i

I heard you can get a dental pick and do it yourself but never talked to anyone who has done it <a href=https://fastpriligy.top/>priligy prescription</a>

, https://fastpriligy.top/, d.m.Y H:i

30, LDH levels greater than 1000 U l, reduced pleural fluid glucose concentration 30 to 50 mg dl, lymphocyte values greater than 50 to 70 <a href=https://fastpriligy.top/>priligy medication</a>

, https://cytotec2buy.top/, d.m.Y H:i

This type of therapy often is most used for severe or painful gynecomasti a <a href=https://cytotec2buy.top/>how to get cheap cytotec without rx</a> With the injection of the diuretic after the radiopharmaceutical F 20 or later, a T 1 2 less than 10 min usually means the absence of obstruction, and a T 1 2 greater than 20 min usually identifies obstruction

https://mcpipokinha23.shop/

Pretty section of content. I just stumbled upon your blog and in accession capital to assert that I get in fact enjoyed account your blog posts. Any way I'll be subscribing to your augment and even I achievement you access consistently fast.

https://mcpipokinha23.shop/

Pretty section of content. I just stumbled upon your blog and in accession capital to assert that I get in fact enjoyed account your blog posts. Any way I'll be subscribing to your augment and even I achievement you access consistently fast.

Ваш комментарий. Вики-синтаксис разрешён:
 
/var/www/wiki.itcall.ru/data/pages/software/windows/base_tempdb_too_big.txt · Последнее изменение: d.m.Y H:i — dbehterev