Viewing 12 posts - 1 through 12 (of 12 total)
Hi
"disconnect users in the database when restoring backups" has been flagged but the strange things is that after restore (terminated with status OK), database "sometimes" it remains in single...
June 5, 2018 at 2:00 am
Now i've monitored the system with PAL and i've alerts on disks with an hint:
"Experimental: HBA Queue Depth might be restricted to 32 - Consider increasing the HBA queue depth...
April 7, 2016 at 2:38 am
I will try...
Now i've to test if problem is caused by mirroring but need to waits some procedures that have to be executed...
April 5, 2016 at 8:49 am
It's relly a mistery...
I'd like to forget sql server but it's difficult because we have 8 disk on this server and the problem appears only in 2 disk (the log...
April 5, 2016 at 3:04 am
Now i've checked perfmon counter log bytes flushed/sec and i've seen that when the mistrious event happens,
this counter GO DOWN. So it means that :
- we have an external process...
April 4, 2016 at 9:25 am
It could be some settings relative to checkpoints? It's very strange! Every database have the same problem with log disk. Exactly every 4 minutes!
April 4, 2016 at 2:25 am
I've seen with perfmon, at the time we have the problems, we also have a peak of disk/writes on disk where is located the log...
April 4, 2016 at 1:54 am
These are total waits time so writelog is always to the top. How can i monitor real time non cumulative waits time?
April 4, 2016 at 1:33 am
I've a lot of writelog waits. I've seen running this query:
WITH Waits AS
(SELECT wait_type, wait_time_ms / 1000. AS wait_time_s,
100. * wait_time_ms / SUM(wait_time_ms) OVER() AS pct,
...
April 1, 2016 at 9:35 am
I've a tool that monitor lock/waits > 1000 ms but it never happens.
I've seen this is not a problem of single database but is relative to the instance. Other procedure...
April 1, 2016 at 9:02 am
Recovery model is simple and filegrouth is 1mb but ther's enough space pre allocated so it never happen that needs to grouth file
April 1, 2016 at 8:27 am
Viewing 12 posts - 1 through 12 (of 12 total)