Viewing 15 posts - 1 through 15 (of 18 total)
June 14, 2017 at 6:02 pm
Output of the query:
SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(qt.TEXT)
ELSE qs.statement_end_offset
END - qs.statement_start_offset)/2)+1),
qs.execution_count,
qs.total_logical_reads, qs.last_logical_reads,
qs.total_logical_writes, qs.last_logical_writes,
qs.total_worker_time,
qs.last_worker_time,
qs.total_elapsed_time/1000000 total_elapsed_time_in_S,
June 14, 2017 at 12:03 pm
June 6, 2017 at 8:21 am
June 5, 2017 at 3:06 am
in waits: ASYNC_NETWORK_IO waits in the database which exceeds 24 hrs ie difference of two days and BACKUP IO waits varies for 1~1.5min(ie difference). So what needs to be done...
June 4, 2017 at 6:47 pm
June 4, 2017 at 6:35 pm
Firstly, those are all also useless waits, so get Glenn Berry's *latest* script,...
June 2, 2017 at 4:54 am
Firstly, those are all also useless waits, so get Glenn Berry's *latest* script,...
June 1, 2017 at 8:57 pm
[code...
June 1, 2017 at 12:21 pm
June 1, 2017 at 5:32 am
May 31, 2017 at 8:25 am
May 31, 2017 at 7:26 am
May 31, 2017 at 7:19 am
Max memory is set to 4096 MB.Auto growth is set to 10%.Manually shrinking of the data base is being done.
RAM is 6GB and in task manager it is...
May 31, 2017 at 1:16 am
Viewing 15 posts - 1 through 15 (of 18 total)