Diẹ ninu awọn aaye ti MS SQL Server ibojuwo. Awọn Itọsọna fun Ṣiṣeto Awọn asia Wa kakiri

Ọrọ iṣaaju

Ni ọpọlọpọ igba, awọn olumulo, awọn olupilẹṣẹ ati awọn alakoso MS SQL Server DBMS wa ni dojuko pẹlu awọn iṣoro iṣẹ ṣiṣe ti ibi ipamọ data tabi DBMS lapapọ, nitorinaa ibojuwo MS SQL Server jẹ pataki pupọ.
Nkan yii jẹ afikun si nkan naa Lilo Zabbix lati Atẹle aaye data olupin MS SQL ati pe yoo ṣe ayẹwo diẹ ninu awọn aaye ti ibojuwo MS SQL Server, ni pataki: bii o ṣe le yara pinnu iru awọn orisun ti o nsọnu, ati awọn iṣeduro fun iṣeto awọn asia itọpa.
Fun awọn iwe afọwọkọ atẹle lati ṣiṣẹ, o nilo lati ṣẹda ero inf kan ninu aaye data ti o fẹ gẹgẹbi atẹle:
Ṣiṣẹda inf ero

use <имя_БД>;
go
create schema inf;

Ọna fun wiwa aini ti Ramu

Atọka akọkọ ti aini Ramu jẹ nigbati apẹẹrẹ ti MS SQL Server jẹ gbogbo Ramu ti a pin si.
Lati ṣe eyi, ṣẹda aṣoju atẹle inf.vRAM:
Ṣiṣẹda wiwo inf.vRAM

CREATE view [inf].[vRAM] as
select a.[TotalAvailOSRam_Mb]						--сколько свободно ОЗУ на сервере в МБ
		 , a.[RAM_Avail_Percent]					--процент свободного ОЗУ на сервере
		 , a.[Server_physical_memory_Mb]				--сколько всего ОЗУ на сервере в МБ
		 , a.[SQL_server_committed_target_Mb]			--сколько всего ОЗУ выделено под MS SQL Server в МБ
		 , a.[SQL_server_physical_memory_in_use_Mb] 		--сколько всего ОЗУ потребляет MS SQL Server в данный момент времени в МБ
		 , a.[SQL_RAM_Avail_Percent]				--поцент свободного ОЗУ для MS SQL Server относительно всего выделенного ОЗУ для MS SQL Server
		 , a.[StateMemorySQL]						--достаточно ли ОЗУ для MS SQL Server
		 , a.[SQL_RAM_Reserve_Percent]				--процент выделенной ОЗУ для MS SQL Server относительно всего ОЗУ сервера
		 --достаточно ли ОЗУ для сервера
		, (case when a.[RAM_Avail_Percent]<10 and a.[RAM_Avail_Percent]>5 and a.[TotalAvailOSRam_Mb]<8192 then 'Warning' when a.[RAM_Avail_Percent]<=5 and a.[TotalAvailOSRam_Mb]<2048 then 'Danger' else 'Normal' end) as [StateMemoryServer]
	from
	(
		select cast(a0.available_physical_memory_kb/1024.0 as int) as TotalAvailOSRam_Mb
			 , cast((a0.available_physical_memory_kb/casT(a0.total_physical_memory_kb as float))*100 as numeric(5,2)) as [RAM_Avail_Percent]
			 , a0.system_low_memory_signal_state
			 , ceiling(b.physical_memory_kb/1024.0) as [Server_physical_memory_Mb]
			 , ceiling(b.committed_target_kb/1024.0) as [SQL_server_committed_target_Mb]
			 , ceiling(a.physical_memory_in_use_kb/1024.0) as [SQL_server_physical_memory_in_use_Mb]
			 , cast(((b.committed_target_kb-a.physical_memory_in_use_kb)/casT(b.committed_target_kb as float))*100 as numeric(5,2)) as [SQL_RAM_Avail_Percent]
			 , cast((b.committed_target_kb/casT(a0.total_physical_memory_kb as float))*100 as numeric(5,2)) as [SQL_RAM_Reserve_Percent]
			 , (case when (ceiling(b.committed_target_kb/1024.0)-1024)<ceiling(a.physical_memory_in_use_kb/1024.0) then 'Warning' else 'Normal' end) as [StateMemorySQL]
		from sys.dm_os_sys_memory as a0
		cross join sys.dm_os_process_memory as a
		cross join sys.dm_os_sys_info as b
		cross join sys.dm_os_sys_memory as v
	) as a;

Lẹhinna o le pinnu pe apẹẹrẹ ti MS SQL Server n gba gbogbo iranti ti a pin si ni lilo ibeere atẹle:

select  SQL_server_physical_memory_in_use_Mb,  SQL_server_committed_target_Mb
from [inf].[vRAM];

Ti itọkasi SQL_server_physical_memory_in_use_Mb ko kere ju SQL_server_committed_target_Mb, lẹhinna o nilo lati ṣayẹwo awọn iṣiro idaduro.
Lati pinnu aini Ramu nipasẹ awọn iṣiro iduro, jẹ ki a ṣẹda wiwo inf.vWaits kan:
Ṣiṣẹda wiwo inf.vWaits

CREATE view [inf].[vWaits] as
WITH [Waits] AS
    (SELECT
        [wait_type], --имя типа ожидания
        [wait_time_ms] / 1000.0 AS [WaitS],--Общее время ожидания данного типа в миллисекундах. Это время включает signal_wait_time_ms
        ([wait_time_ms] - [signal_wait_time_ms]) / 1000.0 AS [ResourceS],--Общее время ожидания данного типа в миллисекундах без signal_wait_time_ms
        [signal_wait_time_ms] / 1000.0 AS [SignalS],--Разница между временем сигнализации ожидающего потока и временем начала его выполнения
        [waiting_tasks_count] AS [WaitCount],--Число ожиданий данного типа. Этот счетчик наращивается каждый раз при начале ожидания
        100.0 * [wait_time_ms] / SUM ([wait_time_ms]) OVER() AS [Percentage],
        ROW_NUMBER() OVER(ORDER BY [wait_time_ms] DESC) AS [RowNum]
    FROM sys.dm_os_wait_stats
    WHERE [waiting_tasks_count]>0
		and [wait_type] NOT IN (
        N'BROKER_EVENTHANDLER',         N'BROKER_RECEIVE_WAITFOR',
        N'BROKER_TASK_STOP',            N'BROKER_TO_FLUSH',
        N'BROKER_TRANSMITTER',          N'CHECKPOINT_QUEUE',
        N'CHKPT',                       N'CLR_AUTO_EVENT',
        N'CLR_MANUAL_EVENT',            N'CLR_SEMAPHORE',
        N'DBMIRROR_DBM_EVENT',          N'DBMIRROR_EVENTS_QUEUE',
        N'DBMIRROR_WORKER_QUEUE',       N'DBMIRRORING_CMD',
        N'DIRTY_PAGE_POLL',             N'DISPATCHER_QUEUE_SEMAPHORE',
        N'EXECSYNC',                    N'FSAGENT',
        N'FT_IFTS_SCHEDULER_IDLE_WAIT', N'FT_IFTSHC_MUTEX',
        N'HADR_CLUSAPI_CALL',           N'HADR_FILESTREAM_IOMGR_IOCOMPLETION',
        N'HADR_LOGCAPTURE_WAIT',        N'HADR_NOTIFICATION_DEQUEUE',
        N'HADR_TIMER_TASK',             N'HADR_WORK_QUEUE',
        N'KSOURCE_WAKEUP',              N'LAZYWRITER_SLEEP',
        N'LOGMGR_QUEUE',                N'ONDEMAND_TASK_QUEUE',
        N'PWAIT_ALL_COMPONENTS_INITIALIZED',
        N'QDS_PERSIST_TASK_MAIN_LOOP_SLEEP',
        N'QDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEP',
        N'REQUEST_FOR_DEADLOCK_SEARCH', N'RESOURCE_QUEUE',
        N'SERVER_IDLE_CHECK',           N'SLEEP_BPOOL_FLUSH',
        N'SLEEP_DBSTARTUP',             N'SLEEP_DCOMSTARTUP',
        N'SLEEP_MASTERDBREADY',         N'SLEEP_MASTERMDREADY',
        N'SLEEP_MASTERUPGRADED',        N'SLEEP_MSDBSTARTUP',
        N'SLEEP_SYSTEMTASK',            N'SLEEP_TASK',
        N'SLEEP_TEMPDBSTARTUP',         N'SNI_HTTP_ACCEPT',
        N'SP_SERVER_DIAGNOSTICS_SLEEP', N'SQLTRACE_BUFFER_FLUSH',
        N'SQLTRACE_INCREMENTAL_FLUSH_SLEEP',
        N'SQLTRACE_WAIT_ENTRIES',       N'WAIT_FOR_RESULTS',
        N'WAITFOR',                     N'WAITFOR_TASKSHUTDOWN',
        N'WAIT_XTP_HOST_WAIT',          N'WAIT_XTP_OFFLINE_CKPT_NEW_LOG',
        N'WAIT_XTP_CKPT_CLOSE',         N'XE_DISPATCHER_JOIN',
        N'XE_DISPATCHER_WAIT',          N'XE_TIMER_EVENT')
    )
, ress as (
	SELECT
	    [W1].[wait_type] AS [WaitType],
	    CAST ([W1].[WaitS] AS DECIMAL (16, 2)) AS [Wait_S],--Общее время ожидания данного типа в миллисекундах. Это время включает signal_wait_time_ms
	    CAST ([W1].[ResourceS] AS DECIMAL (16, 2)) AS [Resource_S],--Общее время ожидания данного типа в миллисекундах без signal_wait_time_ms
	    CAST ([W1].[SignalS] AS DECIMAL (16, 2)) AS [Signal_S],--Разница между временем сигнализации ожидающего потока и временем начала его выполнения
	    [W1].[WaitCount] AS [WaitCount],--Число ожиданий данного типа. Этот счетчик наращивается каждый раз при начале ожидания
	    CAST ([W1].[Percentage] AS DECIMAL (5, 2)) AS [Percentage],
	    CAST (([W1].[WaitS] / [W1].[WaitCount]) AS DECIMAL (16, 4)) AS [AvgWait_S],
	    CAST (([W1].[ResourceS] / [W1].[WaitCount]) AS DECIMAL (16, 4)) AS [AvgRes_S],
	    CAST (([W1].[SignalS] / [W1].[WaitCount]) AS DECIMAL (16, 4)) AS [AvgSig_S]
	FROM [Waits] AS [W1]
	INNER JOIN [Waits] AS [W2]
	    ON [W2].[RowNum] <= [W1].[RowNum]
	GROUP BY [W1].[RowNum], [W1].[wait_type], [W1].[WaitS],
	    [W1].[ResourceS], [W1].[SignalS], [W1].[WaitCount], [W1].[Percentage]
	HAVING SUM ([W2].[Percentage]) - [W1].[Percentage] < 95 -- percentage threshold
)
SELECT [WaitType]
      ,MAX([Wait_S]) as [Wait_S]
      ,MAX([Resource_S]) as [Resource_S]
      ,MAX([Signal_S]) as [Signal_S]
      ,MAX([WaitCount]) as [WaitCount]
      ,MAX([Percentage]) as [Percentage]
      ,MAX([AvgWait_S]) as [AvgWait_S]
      ,MAX([AvgRes_S]) as [AvgRes_S]
      ,MAX([AvgSig_S]) as [AvgSig_S]
  FROM ress
  group by [WaitType];

Ni ọran yii, o le pinnu aini Ramu nipa lilo ibeere atẹle:

SELECT [Percentage]
      ,[AvgWait_S]
  FROM [inf].[vWaits]
  where [WaitType] in (
    'PAGEIOLATCH_XX',
    'RESOURCE_SEMAPHORE',
    'RESOURCE_SEMAPHORE_QUERY_COMPILE'
  );

Nibi o nilo lati san ifojusi si Ogorun ati awọn afihan AvgWait_S. Ti wọn ba ṣe pataki ni apapọ wọn, lẹhinna iṣeeṣe giga wa pe apẹẹrẹ MS SQL Server ko ni Ramu to. Awọn iye pataki jẹ ipinnu ni ẹyọkan fun eto kọọkan. Sibẹsibẹ, o le bẹrẹ pẹlu itọka atẹle: Ogorun>=1 ati AvgWait_S>=0.005.
Lati gbejade awọn afihan si eto ibojuwo (fun apẹẹrẹ, Zabbix), o le ṣẹda awọn ibeere meji wọnyi:

1. Kini ipin ogorun awọn iru iduro fun Ramu (apao fun gbogbo iru awọn iru iduro):

   select coalesce(sum([Percentage]), 0.00) as [Percentage]
   from [inf].[vWaits]
          where [WaitType] in (
              'PAGEIOLATCH_XX',
              'RESOURCE_SEMAPHORE',
               'RESOURCE_SEMAPHORE_QUERY_COMPILE'
     );
   

2. melo ni awọn iru idaduro Ramu gba ni milliseconds (iye ti o pọju ti gbogbo awọn idaduro apapọ fun gbogbo iru awọn iru iduro):

   select coalesce(max([AvgWait_S])*1000, 0.00) as [AvgWait_MS]
   from [inf].[vWaits]
          where [WaitType] in (
              'PAGEIOLATCH_XX',
              'RESOURCE_SEMAPHORE',
               'RESOURCE_SEMAPHORE_QUERY_COMPILE'
     );
   

Da lori awọn agbara ti awọn iye ti o gba fun awọn itọkasi meji wọnyi, a le pinnu boya Ramu ti o to fun apẹẹrẹ olupin MS SQL.

Ọna fun a ri nmu Sipiyu fifuye

Lati ṣe idanimọ aini akoko Sipiyu, o kan lo wiwo eto sys.dm_os_schedulers. Nibi, ti itọkasi runnable_tasks_count jẹ nigbagbogbo tobi ju 1, lẹhinna iṣeeṣe giga wa pe nọmba awọn ohun kohun ko to fun apẹẹrẹ Server MS SQL.
Lati ṣafihan atọka ninu eto ibojuwo (fun apẹẹrẹ, Zabbix), o le ṣẹda ibeere atẹle:

select max([runnable_tasks_count]) as [runnable_tasks_count]
from sys.dm_os_schedulers
where scheduler_id<255;

Da lori awọn agbara ti awọn iye ti o gba fun atọka yii, a le pinnu boya akoko ero isise to to (nọmba awọn ohun kohun Sipiyu) fun apẹẹrẹ MS SQL Server.
Sibẹsibẹ, o ṣe pataki lati ranti otitọ pe awọn ibeere funrara wọn le beere ọpọlọpọ awọn okun ni ẹẹkan. Ati nigba miiran oluṣapejuwe ko le ṣe iṣiro deede idiju ti ibeere naa funrararẹ. Lẹhinna ibeere naa le pin awọn okun lọpọlọpọ, eyiti o ko le ṣe ilana ni akoko kan. Ati pe eyi tun fa iru iduro ti o ni nkan ṣe pẹlu aini akoko ero isise, ati idagba ti isinyi fun awọn oluṣeto ti o lo awọn ohun kohun Sipiyu pato, iyẹn ni, itọkasi runnable_tasks_count yoo pọ si ni iru awọn ipo.
Ni ọran yii, ṣaaju jijẹ nọmba awọn ohun kohun Sipiyu, o nilo lati tunto ni deede awọn ohun-ini parallelism ti apẹẹrẹ MS SQL Server funrararẹ, ati lati ẹya 2016, tunto awọn ohun-ini parallelism ti awọn apoti isura data ti o nilo:



Nibi o yẹ ki o san ifojusi si awọn paramita wọnyi:

1. Iwọn ti o pọju ti Parallelism-ṣeto nọmba ti o pọju ti awọn okun ti o le pin si ibeere kọọkan (aiyipada jẹ 0-lopin nikan nipasẹ ẹrọ ṣiṣe funrararẹ ati ẹda MS SQL Server)
2. Ipele iye owo fun Iparapọ - iye owo ifoju ti parallelism (aiyipada jẹ 5)
3. Max DOP-ṣeto nọmba ti o pọju ti awọn okun ti o le pin si ibeere kọọkan ni ipele data (ṣugbọn kii ṣe ju iye ti ohun-ini "Max Degree of Parallelism") (nipasẹ aiyipada o jẹ 0-ni opin nipasẹ ẹrọ ṣiṣe nikan). funrararẹ ati ẹda MS SQL Server, bakanna bi aropin lori ohun-ini “Max Degree of Parallelism” ti gbogbo apẹẹrẹ olupin MS SQL)

Ko ṣee ṣe lati fun ohunelo to dara deede fun gbogbo awọn ọran, iyẹn ni, o nilo lati ṣe itupalẹ awọn ibeere ti o nira.
Da lori iriri ti ara mi, Mo ṣeduro algorithm atẹle ti awọn iṣe fun awọn eto OLTP lati tunto awọn ohun-ini afiwera:

1. akọkọ mu parallelism ṣiṣẹ nipa tito Iwọn Iwọn ti Parallelism si 1 ni ipele ti gbogbo apẹẹrẹ
2. ṣe itupalẹ awọn ibeere ti o wuwo julọ ki o yan nọmba to dara julọ ti awọn okun fun wọn
3. ṣeto Iwọn Max ti Parallelism si nọmba to dara julọ ti awọn okun ti a gba lati igbesẹ 2, ati tun fun awọn apoti isura infomesonu pato ṣeto iye Max DOP ti o gba lati igbesẹ 2 fun data kọọkan
4. ṣe itupalẹ awọn ibeere ti o wuwo julọ ati ṣe idanimọ ipa odi ti multithreading. Ti o ba jẹ bẹ, lẹhinna mu Ipele iye owo pọ si fun Iparapọ.
   Fun awọn ọna ṣiṣe bii 1C, Microsoft CRM ati Microsoft NAV, ni ọpọlọpọ igba idinamọ multithreading dara

Paapaa, ti o ba ni atẹjade Standard, lẹhinna ni ọpọlọpọ igba idinamọ lori titẹ-pupọ jẹ deede nitori otitọ pe ẹda yii ni opin ni nọmba awọn ohun kohun Sipiyu.
Algoridimu ti a ṣalaye loke ko dara fun awọn eto OLAP.
Da lori iriri ti ara mi, Mo ṣeduro algorithm atẹle ti awọn iṣe fun awọn eto OLAP lati tunto awọn ohun-ini afiwera:

1. ṣe itupalẹ awọn ibeere ti o wuwo julọ ki o yan nọmba to dara julọ ti awọn okun fun wọn
2. ṣeto Iwọn Max ti Parallelism si nọmba to dara julọ ti awọn okun ti a gba lati igbesẹ 1, ati tun fun awọn apoti isura infomesonu pato ṣeto iye Max DOP ti o gba lati igbesẹ 1 fun data kọọkan
3. itupalẹ awọn heaviest ibeere ati ki o da awọn odi ipa ti diwọn concurrency. Ti o ba jẹ bẹ, lẹhinna boya isalẹ Ilẹ-iwọn iye owo fun iye ti o jọra, tabi tun awọn igbesẹ 1-2 ti algorithm yii ṣe.

Iyẹn ni, fun awọn ọna ṣiṣe OLTP a lọ lati titẹ-ẹyọkan si ṣiṣan-ọpọlọpọ, ati fun awọn ọna ṣiṣe OLAP, ni ilodi si, a lọ lati ọpọ-threading si titẹ-ẹyọkan. Ni ọna yii o le yan awọn eto parallelism ti o dara julọ mejeeji fun aaye data kan pato ati fun gbogbo apẹẹrẹ olupin MS SQL.
O tun ṣe pataki lati ni oye pe awọn eto awọn ohun-ini concurrency nilo lati yipada ni akoko pupọ, da lori awọn abajade ti ibojuwo iṣẹ ti MS SQL Server.

Awọn iṣeduro fun iṣeto awọn asia itọpa

Lati iriri ti ara mi ati iriri ti awọn ẹlẹgbẹ mi, fun iṣẹ ṣiṣe to dara julọ, Mo ṣeduro ṣeto awọn asia itọpa wọnyi ni ipele ṣiṣe iṣẹ MS SQL Server fun awọn ẹya 2008-2016:

1. 610 - Din gedu awọn ifibọ sinu awọn tabili atọka. Le ṣe iranlọwọ pẹlu awọn ifibọ sinu awọn tabili pẹlu nọmba nla ti awọn igbasilẹ ati ọpọlọpọ awọn iṣowo, pẹlu igba pipẹ WRITELOG nduro fun awọn ayipada ninu awọn atọka
2. 1117 - Ti faili kan ninu ẹgbẹ faili ba pade ala-idagba adaṣe, gbogbo awọn faili ti o wa ninu ẹgbẹ faili ti dagba
3. 1118 - Fi agbara mu gbogbo awọn nkan lati wa ni awọn iwọn oriṣiriṣi (fi gba awọn iwọn idapọmọra), eyiti o dinku iwulo lati ṣe ọlọjẹ oju-iwe SGAM, eyiti o lo lati tọpa awọn iwọn idapọmọra
4. 1224 - Mu titiipa titiipa da lori kika titiipa. Bibẹẹkọ, lilo iranti ti o pọ ju le jẹ ki ilọsoke titiipa ṣiṣẹ
5. 2371 - Ṣe iyipada ala imudojuiwọn awọn iṣiro adaṣe adaṣe ti o wa titi si iloro imudojuiwọn awọn iṣiro adaṣe adaṣe. Pataki fun imudojuiwọn awọn ero ibeere lori awọn tabili nla nibiti asọye ti ko tọ si nọmba awọn abajade igbasilẹ ni awọn ero ipaniyan aṣiṣe.
6. 3226 - Dinku awọn ifiranṣẹ aṣeyọri afẹyinti ni akọọlẹ aṣiṣe
7. 4199 - Pẹlu awọn iyipada si iṣapeye ibeere ti o tu silẹ ni awọn imudojuiwọn imudojuiwọn SQL Server ati awọn akopọ iṣẹ
8. 6532-6534 - Pẹlu awọn ilọsiwaju iṣẹ fun awọn ibeere pẹlu awọn iru data aaye
9. 8048 - Ṣe iyipada awọn nkan iranti ti ipin NUMA si awọn ti o pin Sipiyu
10. 8780 - Nṣiṣẹ afikun akoko ipinfunni fun igbero ibeere. Diẹ ninu awọn ibeere laisi asia yii le jẹ kọ nitori wọn ko ni ero ibeere (aṣiṣe to ṣọwọn pupọ)
11. 8780 - 9389 - Nṣiṣẹ afikun ifipamọ iranti igba diẹ ti o ni agbara fun awọn oniṣẹ ipo ipele, gbigba oniṣẹ ipo ipele lati beere iranti afikun ati yago fun gbigbe data si tempdb ti iranti afikun ba wa.

O tun wulo lati mu asia itọpa 2016 ṣiṣẹ ṣaaju ẹya 2301, eyiti o jẹ ki ipinnu ipinnu ilọsiwaju dara julọ ati nitorinaa ṣe iranlọwọ ni yiyan awọn ero ibeere to dara julọ. Sibẹsibẹ, lati ẹya 2016, o nigbagbogbo ni ipa odi lori awọn akoko ipaniyan gbogbogbo gigun.
Paapaa, fun awọn eto pẹlu ọpọlọpọ awọn atọka (fun apẹẹrẹ, fun awọn apoti isura infomesonu 1C), Mo ṣeduro muu asia itọpa 2330 ṣiṣẹ, eyiti o ṣe idiwọ gbigba ti lilo atọka, eyiti o ni ipa rere lori eto naa ni gbogbogbo.
O le kọ ẹkọ diẹ sii nipa awọn asia itọpa nibi
Lati ọna asopọ ti o wa loke, o tun ṣe pataki lati ṣe akiyesi awọn ẹya ati awọn itumọ ti MS SQL Server, bi fun awọn ẹya tuntun, diẹ ninu awọn asia itọpa ti ṣiṣẹ nipasẹ aiyipada tabi ko ni ipa.
O le mu ṣiṣẹ tabi mu asia itọpa kuro nipa lilo awọn aṣẹ DBCC TRACEON ati DBCC TRACEOFF, lẹsẹsẹ. Wo alaye diẹ sii nibi
O le gba ipo awọn asia itọpa nipa lilo aṣẹ DBCC TRACESTATUS: awọn alaye diẹ sii
Ni ibere fun awọn asia itọpa lati wa ninu autostart ti iṣẹ olupin MS SQL, o nilo lati lọ si Oluṣakoso Iṣeto SQL Server ki o ṣafikun awọn asia itọpa wọnyi nipasẹ -T ninu awọn ohun-ini iṣẹ:

Awọn esi

Nkan yii ṣe ayẹwo diẹ ninu awọn aaye ti ibojuwo MS SQL Server, pẹlu iranlọwọ ti eyiti o le ṣe idanimọ aini Ramu ati akoko Sipiyu ọfẹ, ati nọmba awọn iṣoro miiran ti ko han gbangba. Awọn asia itọpa ti o wọpọ julọ ni a ṣe atunyẹwo.

Awọn orisun:

» SQL Server Duro Statistics
» Awọn iṣiro idaduro SQL Server tabi jọwọ sọ fun mi ibiti o ti dun
» Wiwo eto sys.dm_os_schedulers
» Lilo Zabbix lati Atẹle aaye data olupin MS SQL
» SQL Igbesi aye
» Awọn asia wa kakiri
» sql.ru

orisun: www.habr.com