September 30, 2014 at 9:59 am
Is there any way to find how much time it will take to restart the sql server.
sql server tempdb is getting full in report server. Need to restart the server to clear the space issue. How much time it will take to restart
September 30, 2014 at 10:23 am
Anything from a couple minutes upward. I've seen 13 hours, I've heard of a couple of days.
Why restart? If TempDB is full, make the files larger. Interrupting everyone because you've got the files sized too small doesn't make sense.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2014 at 10:31 am
do you have the SQL errorlog covering the last restart, that will tell you.
---------------------------------------------------------------------
September 30, 2014 at 11:11 am
From the below query the values of temp db files are 15217MB, 56617MB. Autogrowth is on & growth value 10
SELECT
name AS FileName,
size*1.0/128 AS FileSizeinMB,
CASE max_size
WHEN 0 THEN 'Autogrowth is off.'
WHEN -1 THEN 'Autogrowth is on.'
ELSE 'Log file will grow to a maximum size of 2 TB.'
END,
growth AS 'GrowthValue',
'GrowthIncrement' =
CASE
WHEN growth = 0 THEN 'Size is fixed and will not grow.'
WHEN growth > 0 AND is_percent_growth = 0
THEN 'Growth value is in 8-KB pages.'
ELSE 'Growth value is a percentage.'
END
FROM tempdb.sys.database_files;
GO
September 30, 2014 at 11:33 am
I go and check D:\MSSQL\MSRS11.MSSQLSERVER\Reportingservices\Logfiles
In that logfile, I can see
appdomainmanger!Defai;tdomain!..::e Error while performing memory shrink: system out of memory exception: Exception of Type, 'system.outofmemoryexception;, was thrown
September 30, 2014 at 12:33 pm
ramana3327 (9/30/2014)
I go and check D:\MSSQL\MSRS11.MSSQLSERVER\Reportingservices\Logfiles
Why are you looking in the SQL Server Reporting Services logs?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply