Microsoft SQL Server'da Veritabanlarının Ortalama Okuma Yazma Hızı

SELECT DB_NAME(s.database_id) AS Database_Name ,

    SUM(s.user_seeks +0.000

      + s.user_scans 

      + s.user_lookups 

      + s.system_seeks

      + s.system_scans 

      + s.system_lookups) / SUM(s.user_seeks

                    + s.user_scans

                    + s.user_lookups

                    + s.user_updates

                    + s.system_seeks

                    + s.system_scans

                    + s.system_lookups

                    + s.system_updates) AS Read_Percentage ,

    SUM(s.user_updates + 0.000

      + s.system_updates) / SUM(s.user_seeks

                    + s.user_scans

                    + s.user_lookups

                    + s.user_updates

                    + s.system_seeks

                    + s.system_scans

                    + s.system_lookups

                    + s.system_updates) AS Write_Percentage

FROM  sys.dm_db_index_usage_stats AS s

GROUP BY s.database_id

ORDER BY DB_NAME(s.database_id)

Uyarlama İçin:
Onem Bilişim İletişim Ltd. Şti.

 

Makale Detayları

Makale Kodu :
260
Görüntüleme :
24
Oylama (Oylar):
(0)

Benzer Makaleler