Some Notes, Some Scripts
These are the noted taken for searching solutions and some scripts to identify the problem
Categories:
SELECT parent_node_id ,COUNT(*) as [Schedulers] ,SUM(current_tasks_count) as [Current] ,SUM(runnable_tasks_count) as [Runnable] FROM sys.dm_os_schedulers WHERE status = ‘VISIBLE ONLINE’ GROUP BY parent_node_id;
Categories:
There are four different types of checkpoints: Internal checkpointsInternal checkpoints occur during some SQL Server operations, such as starting database backup or creating a database snapshot.Manual checkpointsManual checkpoint occur manually, as the name indicates, when users trigger them […]
Categories:
SQL Server için tanımlanan memory alanı ne kadar yeterli sorusuna en iyi cevabı verecek olan sorgudur. PLE özetle, cache üzerinde bir verinin ne kadar süre kaldığını gösterir. Eğer bu süre uzun ise sorun yok. Ama kısa ise bu […]
Categories:
When any connection starts the value of the SET LOCK_TIMEOUT is -1, which means that the query has to wait for infinite time for the lock to be released on another query. If you want to simulate the scenario […]