sqlserver20xxperformancedatacollection-文庫吧資料
2024-10-08 13:55本頁面
【正文】 ata Collection Components What runs where? Mar2022 10 Microsoft Developer amp。 Platform Evangelism Map Logins and Users Mar2022 8 Microsoft Developer amp。 Platform Evangelism Cache Directory Stores frequently gathers data points but uploads them as a second and separate step (data collection will have 2 jobs) Local to the server on which data collection is being performed Defaults to local %temp% directory If directory is changed, make sure that the local SQL Server Agent has rights to read/write to this directory – all cached data collection will fail (Server Activity and Query Statistics are cached by default in CTP6) Files stored in the cache directory follow these naming conventions: ? servername_mssql10_instance_{{GUID}}_.cache Mar2022 6 Microsoft Developer amp。 data estimates are 250350MB per day/per DB ? Data/Log on separate drives ? Recovery model should reflect backup/restore strategy ? May want to precreate a more custom/optimized database and select this database rather than create it as part of the MDW wizard Mar2022 4 Microsoft Developer amp。 Platform Evangelism Module Overview Management Data Warehouse Performance Data Collection ? Performance data collection ponents ? System collection sets ? Userdefined collection sets ? Reporting Centralized Administration: Bringing it all together Performance Data Collection and Reporting Mar2022 3 Microsoft Developer amp。Essential SQL Server 2022 Database Infrastructure and Scalability Module 3 – Performance Data Collection Disclaimer The information contained in this slide deck represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a mitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication. This slide deck is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.
規(guī)章制度相關(guān)推薦
鄂ICP備17016276號-1