{"id":14937,"date":"2024-08-22T12:09:21","date_gmt":"2024-08-22T04:09:21","guid":{"rendered":"https:\/\/www.simcentric.com\/uncategorized-sc\/what-techniques-boost-sql-server-efficiency\/"},"modified":"2024-08-22T12:17:20","modified_gmt":"2024-08-22T04:17:20","slug":"what-techniques-boost-sql-server-efficiency","status":"publish","type":"post","link":"https:\/\/www.simcentric.com\/sc\/hong-kong-dedicated-server-sc\/what-techniques-boost-sql-server-efficiency\/","title":{"rendered":"\u54ea\u4e9b\u6280\u672f\u53ef\u4ee5\u63d0\u9ad8SQL Server\u7684\u6548\u7387?"},"content":{"rendered":"

[vc_row el_class=”blog-detail-section”][vc_column][vc_column_text]<\/p>\n

\u5728\u5f53\u4eca\u6570\u636e\u9a71\u52a8\u7684\u4e16\u754c\u4e2d,\u4f18\u5316SQL Server<\/a><\/strong>\u6027\u80fd\u5e76\u5229\u7528\u5176\u9ad8\u7ea7\u529f\u80fd\u5bf9\u4f01\u4e1a\u4fdd\u6301\u7ade\u4e89\u4f18\u52bf\u81f3\u5173\u91cd\u8981,\u7279\u522b\u662f\u5bf9\u4e8e\u72ec\u7acb\u670d\u52a1\u5668<\/a><\/strong>\u7528\u6237\u800c\u8a00\u3002\u672c\u6587\u6df1\u5165\u63a2\u8ba8\u4e86\u590d\u6742\u7684SQL Server\u4f18\u5316\u6280\u672f\u548c\u5e94\u7528,\u91cd\u70b9\u5173\u6ce8\u9ad8\u53ef\u7528\u6027\u89e3\u51b3\u65b9\u6848\u3001\u6570\u636e\u8fc1\u79fb\u7b56\u7565\u3001\u62a5\u8868\u670d\u52a1\u4ee5\u53ca\u6709\u6548\u7684\u76d1\u63a7\u548c\u6545\u969c\u6392\u9664\u5b9e\u8df5\u3002<\/p>\n

[\/vc_column_text][\/vc_column][\/vc_row][vc_row el_class=”blog-detail-section”][vc_column][vc_column_text]<\/p>\n

1. SQL Server\u4e2d\u7684\u9ad8\u53ef\u7528\u6027\u89e3\u51b3\u65b9\u6848<\/h2>\n

\u5728\u73b0\u4ee3\u5546\u4e1a\u73af\u5883\u4e2d,\u786e\u4fdd\u5173\u952e\u6570\u636e\u7684\u6301\u7eed\u8bbf\u95ee\u81f3\u5173\u91cd\u8981\u3002SQL Server\u63d0\u4f9b\u4e86\u51e0\u79cd\u9ad8\u53ef\u7528\u6027\u89e3\u51b3\u65b9\u6848,\u4ee5\u6700\u5927\u9650\u5ea6\u5730\u51cf\u5c11\u505c\u673a\u65f6\u95f4\u5e76\u4fdd\u6301\u6570\u636e\u7684\u53ef\u8bbf\u95ee\u6027\u3002<\/p>\n

1.1 AlwaysOn\u53ef\u7528\u6027\u7ec4<\/h3>\n

AlwaysOn\u53ef\u7528\u6027\u7ec4\u4e3a\u6570\u636e\u5e93\u7ea7\u9ad8\u53ef\u7528\u6027\u548c\u707e\u96be\u6062\u590d\u63d0\u4f9b\u4e86\u5f3a\u5927\u7684\u89e3\u51b3\u65b9\u6848\u3002\u4ee5\u4e0b\u662f\u521b\u5efa\u53ef\u7528\u6027\u7ec4\u7684\u57fa\u672cT-SQL\u811a\u672c:<\/p>\n

-- Create the availability group\r\nCREATE AVAILABILITY GROUP [AG_PrimaryDatabase]\r\nFOR DATABASE [PrimaryDatabase]\r\nREPLICA ON \r\n'PrimaryServer' WITH (ENDPOINT_URL = 'TCP:\/\/PrimaryServer:5022',\r\n    FAILOVER_MODE = AUTOMATIC,\r\n    AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,\r\n    BACKUP_PRIORITY = 50,\r\n    SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL)),\r\n'SecondaryServer' WITH (ENDPOINT_URL = 'TCP:\/\/SecondaryServer:5022',\r\n    FAILOVER_MODE = AUTOMATIC,\r\n    AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,\r\n    BACKUP_PRIORITY = 50,\r\n    SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL));\r\n\r\n-- Join the secondary replica to the availability group\r\nALTER AVAILABILITY GROUP [AG_PrimaryDatabase] JOIN;\r\n\r\n-- Create a listener for the availability group\r\nALTER AVAILABILITY GROUP [AG_PrimaryDatabase]\r\nADD LISTENER 'AGListener' (\r\n    WITH IP\r\n    ((N'10.0.0.30', N'255.255.255.0')\r\n    )\r\n    , PORT=1433);<\/code><\/pre>\n
\u8fd9\u79cd\u914d\u7f6e\u786e\u4fdd\u4e86\u4e3b\u670d\u52a1\u5668\u548c\u8f85\u52a9\u670d\u52a1\u5668\u4e4b\u95f4\u7684\u81ea\u52a8\u6545\u969c\u8f6c\u79fb\u548c\u540c\u6b65\u6570\u636e\u590d\u5236\u3002<\/p>\n
1.2 \u6545\u969c\u8f6c\u79fb\u96c6\u7fa4\u5b9e\u4f8b(FCI)<\/h3>\n
\u6545\u969c\u8f6c\u79fb\u96c6\u7fa4\u5b9e\u4f8b\u63d0\u4f9b\u5b9e\u4f8b\u7ea7\u9ad8\u53ef\u7528\u6027\u3002\u8981\u8bbe\u7f6eFCI,\u60a8\u9700\u8981\u914d\u7f6eWindows Server\u6545\u969c\u8f6c\u79fb\u96c6\u7fa4(WSFC),\u7136\u540e\u5c06SQL Server\u5b89\u88c5\u4e3a\u96c6\u7fa4\u89d2\u8272\u3002\u4ee5\u4e0b\u662f\u5c06SQL Server\u8d44\u6e90\u6dfb\u52a0\u5230\u73b0\u6709WSFC\u7684PowerShell\u811a\u672c:<\/p>\n
Import-Module FailoverClusters\r\n\r\nAdd-ClusterResource -Name \"SQL Server\" -Group \"SQL Server Group\" -ResourceType \"SQL Server\"\r\n\r\n# Set dependencies\r\nAdd-ClusterResourceDependency -Resource \"SQL Server\" -Provider \"SQL Network Name\"\r\nAdd-ClusterResourceDependency -Resource \"SQL Server\" -Provider \"SQL IP Address\"\r\n\r\n# Configure the SQL Server resource\r\nSet-ClusterParameter -Name VirtualServerName -Value \"SQLCLUSTER\" -InputObject (Get-ClusterResource \"SQL Server\")\r\nSet-ClusterParameter -Name InstanceName -Value \"MSSQLSERVER\" -InputObject (Get-ClusterResource \"SQL Server\")\r\n\r\n# Bring the SQL Server resource online\r\nStart-ClusterResource \"SQL Server\"<\/code><\/pre>\n
1.3 \u6570\u636e\u5e93\u955c\u50cf<\/h3>\n
\u867d\u7136\u6570\u636e\u5e93\u955c\u50cf\u6b63\u5728\u88ab\u53ef\u7528\u6027\u7ec4\u6240\u53d6\u4ee3,\u4f46\u5728\u67d0\u4e9b\u73af\u5883\u4e2d\u4ecd\u5728\u4f7f\u7528\u3002\u4ee5\u4e0b\u662f\u5982\u4f55\u8bbe\u7f6e\u6570\u636e\u5e93\u955c\u50cf:<\/p>\n
-- On the principal server\r\nALTER DATABASE [YourDatabase] SET RECOVERY FULL;\r\nBACKUP DATABASE [YourDatabase] TO DISK = 'C:\\YourDatabase.bak';\r\nBACKUP LOG [YourDatabase] TO DISK = 'C:\\YourDatabase_log.bak';\r\n\r\n-- On the mirror server\r\nRESTORE DATABASE [YourDatabase] FROM DISK = 'C:\\YourDatabase.bak'\r\nWITH NORECOVERY;\r\nRESTORE LOG [YourDatabase] FROM DISK = 'C:\\YourDatabase_log.bak'\r\nWITH NORECOVERY;\r\n\r\n-- On the principal server\r\nALTER DATABASE [YourDatabase] SET PARTNER = 'TCP:\/\/MirrorServer:5022';\r\n\r\n-- On the mirror server\r\nALTER DATABASE [YourDatabase] SET PARTNER = 'TCP:\/\/PrincipalServer:5022';<\/code><\/pre>\n
[\/vc_column_text][\/vc_column][\/vc_row][vc_row el_class=”blog-detail-section”][vc_column][vc_column_text]<\/p>\n
2. \u6570\u636e\u8fc1\u79fb\u6280\u672f<\/h2>\n
\u5728\u5347\u7ea7\u7cfb\u7edf\u3001\u6574\u5408\u6570\u636e\u5e93\u6216\u8fc1\u79fb\u5230\u4e91\u73af\u5883\u65f6,\u6709\u6548\u7684\u6570\u636e\u8fc1\u79fb\u81f3\u5173\u91cd\u8981\u3002SQL Server\u63d0\u4f9b\u4e86\u5404\u79cd\u5de5\u5177\u548c\u6280\u672f,\u7528\u4e8e\u65e0\u7f1d\u6570\u636e\u8fc1\u79fb\u3002<\/p>\n
2.1 SQL Server\u8fc1\u79fb\u52a9\u624b(SSMA)<\/h3>\n
SSMA\u4fbf\u4e8e\u4ece\u5404\u79cd\u6570\u636e\u5e93\u5e73\u53f0\u8fc1\u79fb\u5230SQL Server\u3002\u867d\u7136\u5b83\u662f\u4e00\u4e2aGUI\u5de5\u5177,\u4f46\u60a8\u53ef\u4ee5\u4f7f\u7528\u547d\u4ee4\u884c\u64cd\u4f5c\u81ea\u52a8\u5316SSMA:<\/p>\n
SSMAforDB2Console.exe \/s:scriptfile.xml \/c:commandfile.xml \/v:verbose<\/code><\/pre>\n
XML\u6587\u4ef6\u5206\u522b\u5305\u542b\u8fc1\u79fb\u8bbe\u7f6e\u548c\u547d\u4ee4\u3002<\/p>\n
2.2 \u6279\u91cf\u590d\u5236\u7a0b\u5e8f(BCP)<\/h3>\n
BCP\u5bf9\u4e8e\u79fb\u52a8\u5927\u91cf\u6570\u636e\u975e\u5e38\u9ad8\u6548\u3002\u4ee5\u4e0b\u662f\u4f7f\u7528BCP\u5bfc\u51fa\u6570\u636e\u7684\u793a\u4f8b:<\/p>\n
bcp \"SELECT * FROM SourceDB.dbo.Table\" queryout \"C:\\ExportedData.txt\" -c -T<\/code><\/pre>\n
\u5bfc\u5165\u6570\u636e:<\/p>\n
bcp TargetDB.dbo.Table in \"C:\\ExportedData.txt\" -c -T<\/code><\/pre>\n
2.3 SQL Server\u96c6\u6210\u670d\u52a1(SSIS)<\/h3>\n
SSIS\u4e3a\u590d\u6742\u7684\u6570\u636e\u8fc1\u79fb\u63d0\u4f9b\u4e86\u5f3a\u5927\u7684ETL\u5de5\u5177\u3002\u4ee5\u4e0b\u662f\u7528\u4e8e\u6570\u636e\u4f20\u8f93\u7684SSIS\u5305\u811a\u672c\u4efb\u52a1\u793a\u4f8b:<\/p>\n
using System;\r\nusing System.Data;\r\nusing Microsoft.SqlServer.Dts.Runtime;\r\nusing System.Windows.Forms;\r\n\r\npublic void Main()\r\n{\r\n    string sourceConnectionString = \"Data Source=SourceServer;Initial Catalog=SourceDB;Integrated Security=SSPI;\";\r\n    string destinationConnectionString = \"Data Source=DestServer;Initial Catalog=DestDB;Integrated Security=SSPI;\";\r\n    string query = \"SELECT * FROM SourceTable\";\r\n\r\n    using (SqlConnection sourceConnection = new SqlConnection(sourceConnectionString))\r\n    using (SqlConnection destinationConnection = new SqlConnection(destinationConnectionString))\r\n    {\r\n        sourceConnection.Open();\r\n        destinationConnection.Open();\r\n\r\n        using (SqlCommand command = new SqlCommand(query, sourceConnection))\r\n        using (SqlDataReader reader = command.ExecuteReader())\r\n        using (SqlBulkCopy bulkCopy = new SqlBulkCopy(destinationConnection))\r\n        {\r\n            bulkCopy.DestinationTableName = \"DestinationTable\";\r\n            bulkCopy.WriteToServer(reader);\r\n        }\r\n    }\r\n\r\n    Dts.TaskResult = (int)ScriptResults.Success;\r\n}<\/code><\/pre>\n
[\/vc_column_text][\/vc_column][\/vc_row][vc_row el_class=”blog-detail-section”][vc_column][vc_column_text]<\/p>\n
3. SQL Server\u62a5\u8868\u670d\u52a1(SSRS)\u5e94\u7528<\/h2>\n
SSRS\u4e3a\u5728SQL Server\u73af\u5883\u4e2d\u521b\u5efa\u548c\u7ba1\u7406\u62a5\u8868\u63d0\u4f9b\u4e86\u5168\u9762\u7684\u5e73\u53f0\u3002<\/p>\n
3.1 \u521b\u5efa\u52a8\u6001\u62a5\u8868<\/h3>\n
\u4f7f\u7528\u62a5\u8868\u751f\u6210\u5668\u6216Visual Studio\u521b\u5efa\u52a8\u6001\u62a5\u8868\u3002\u4ee5\u4e0b\u662f\u53c2\u6570\u5316\u62a5\u8868\u7684\u793a\u4f8bSQL\u67e5\u8be2:<\/p>\n
SELECT \r\n    OrderDate,\r\n    ProductName,\r\n    Quantity,\r\n    UnitPrice,\r\n    (Quantity * UnitPrice) AS TotalSale\r\nFROM \r\n    Sales.OrderDetails od\r\n    JOIN Sales.Orders o ON od.OrderID = o.OrderID\r\n    JOIN Production.Products p ON od.ProductID = p.ProductID\r\nWHERE \r\n    OrderDate BETWEEN @StartDate AND @EndDate\r\n    AND ProductCategoryID = @CategoryID<\/code><\/pre>\n
3.2 \u5c06\u62a5\u8868\u90e8\u7f72\u5230SSRS<\/h3>\n
\u4f7f\u7528Web\u95e8\u6237\u6216PowerShell\u90e8\u7f72\u62a5\u8868\u3002\u4ee5\u4e0b\u662f\u7528\u4e8e\u90e8\u7f72\u62a5\u8868\u7684PowerShell\u811a\u672c:<\/p>\n
$reportServerUri = \"http:\/\/your-server\/reportserver\"\r\n$reportPath = \"\/Folder\/ReportName\"\r\n$reportDefinition = Get-Content \"C:\\Reports\\YourReport.rdl\"\r\n\r\n$proxy = New-WebServiceProxy -Uri \"$reportServerUri\/ReportService2010.asmx\" -UseDefaultCredential\r\n$type = $proxy.GetType().Namespace\r\n\r\n$dataSourceReference = New-Object (\"$type.DataSourceReference\")\r\n$dataSourceReference.Reference = \"\/Datasources\/YourDataSource\"\r\n\r\n$properties = New-Object (\"$type.Property[]\") 1\r\n$properties[0] = New-Object (\"$type.Property\")\r\n$properties[0].Name = \"DataSourceReference\"\r\n$properties[0].Value = $dataSourceReference.Reference\r\n\r\n$proxy.CreateCatalogItem(\"Report\", $reportName, $reportPath, $true, $reportDefinition, $properties, [ref]$warnings)<\/code><\/pre>\n
3.3 \u8ba1\u5212\u548c\u8ba2\u9605<\/h3>\n
\u8bbe\u7f6e\u62a5\u8868\u8ba2\u9605\u4ee5\u5b9e\u73b0\u81ea\u52a8\u4ea4\u4ed8\u3002\u4ee5\u4e0b\u662f\u521b\u5efa\u6570\u636e\u9a71\u52a8\u8ba2\u9605\u7684T-SQL\u811a\u672c:<\/p>\n
DECLARE @SubscriptionID uniqueidentifier\r\nEXEC msdb.dbo.sp_add_subscription\r\n    @report_id = '5741DF42-FEA2-4F74-AAAA-12345D4E217C',\r\n    @subscription_id = @SubscriptionID OUTPUT,\r\n    @owner_id = '1234ABCD-12AB-12AB-12AB-12345678ABCD',\r\n    @report_name = 'SalesReport',\r\n    @subscriber_description = 'Data-Driven Subscription',\r\n    @datasource_name = 'Subscribers',\r\n    @query = 'SELECT Email, Name FROM Subscribers WHERE Active = 1',\r\n    @notify_fields_type = 1,\r\n    @notify_fields = 'Email',\r\n    @delivery_extension = 'Report Server Email',\r\n    @render_format = 'PDF'\r\n\r\nEXEC msdb.dbo.sp_add_subscription_event \r\n    @subscription_id = @SubscriptionID,\r\n    @event_type = 'shared_schedule',\r\n    @schedule_id = 'B5CA5C5C-8DFA-4DCA-94EE-12345CCB9F56'<\/code><\/pre>\n
[\/vc_column_text][\/vc_column][\/vc_row][vc_row el_class=”blog-detail-section”][vc_column][vc_column_text]<\/p>\n
4. SQL Server\u76d1\u63a7\u548c\u6545\u969c\u6392\u9664<\/h2>\n
\u6709\u6548\u7684\u76d1\u63a7\u548c\u6545\u969c\u6392\u9664<\/a><\/strong>\u5bf9\u4e8e\u7ef4\u62a4\u6700\u4f73SQL Server\u6027\u80fd\u81f3\u5173\u91cd\u8981\u3002<\/p>\n
4.1 \u4f7f\u7528\u52a8\u6001\u7ba1\u7406\u89c6\u56fe(DMV)<\/h3>\n
DMV\u63d0\u4f9b\u4e86\u6709\u5173\u670d\u52a1\u5668\u6027\u80fd\u7684\u5b9d\u8d35\u6d1e\u5bdf\u3002\u4ee5\u4e0b\u662f\u7528\u4e8e\u8bc6\u522b\u6d88\u8017\u6700\u591a\u8d44\u6e90\u7684\u67e5\u8be2\u7684\u67e5\u8be2:<\/p>\n
SELECT TOP 10\r\n    qs.execution_count,\r\n    qs.total_logical_reads, qs.last_logical_reads,\r\n    qs.total_logical_writes, qs.last_logical_writes,\r\n    qs.total_worker_time, qs.last_worker_time,\r\n    qs.total_elapsed_time\/1000000 total_elapsed_time_in_S,\r\n    qs.last_elapsed_time\/1000000 last_elapsed_time_in_S,\r\n    qs.last_execution_time,\r\n    qp.query_plan\r\nFROM \r\n    sys.dm_exec_query_stats qs\r\nCROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st\r\nCROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp\r\nORDER BY \r\n    qs.total_logical_reads DESC<\/code><\/pre>\n
4.2 \u7528\u4e8e\u9ad8\u7ea7\u76d1\u63a7\u7684\u6269\u5c55\u4e8b\u4ef6<\/h3>\n
\u4f7f\u7528\u6269\u5c55\u4e8b\u4ef6\u8fdb\u884c\u8be6\u7ec6\u7684\u6027\u80fd\u76d1\u63a7\u3002\u4ee5\u4e0b\u662f\u521b\u5efa\u6269\u5c55\u4e8b\u4ef6\u4f1a\u8bdd\u4ee5\u6355\u83b7\u67e5\u8be2\u8d85\u65f6\u7684\u811a\u672c:<\/p>\n
CREATE EVENT SESSION [CaptureQueryTimeouts] ON SERVER \r\nADD EVENT sqlserver.rpc_completed(\r\n    ACTION(sqlserver.client_app_name,sqlserver.client_hostname,sqlserver.database_name,sqlserver.session_id,sqlserver.sql_text)\r\n    WHERE ([result]=(2))),\r\nADD EVENT sqlserver.sql_batch_completed(\r\n    ACTION(sqlserver.client_app_name,sqlserver.client_hostname,sqlserver.database_name,sqlserver.session_id,sqlserver.sql_text)\r\n    WHERE ([result]=(2)))\r\nADD TARGET package0.event_file(SET filename=N'C:\\Logs\\QueryTimeouts.xel')\r\nWITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)\r\nGO\r\n\r\nALTER EVENT SESSION [CaptureQueryTimeouts] ON SERVER STATE = START;<\/code><\/pre>\n
4.3 \u4f7f\u7528\u67e5\u8be2\u5b58\u50a8\u8fdb\u884c\u6027\u80fd\u8c03\u4f18<\/h3>\n
\u67e5\u8be2\u5b58\u50a8\u63d0\u4f9b\u4e86\u968f\u65f6\u95f4\u53d8\u5316\u7684\u67e5\u8be2\u6027\u80fd\u6d1e\u5bdf\u3002\u4ee5\u4e0b\u662f\u5982\u4f55\u542f\u7528\u548c\u4f7f\u7528\u67e5\u8be2\u5b58\u50a8:<\/p>\n
ALTER DATABASE YourDatabase\r\nSET QUERY_STORE = ON \r\n(\r\n    OPERATION_MODE = READ_WRITE,\r\n    CLEANUP_POLICY = ( STALE_QUERY_THRESHOLD_DAYS = 30 ),\r\n    DATA_FLUSH_INTERVAL_SECONDS = 3000,\r\n    INTERVAL_LENGTH_MINUTES = 15,\r\n    MAX_STORAGE_SIZE_MB = 1000,\r\n    QUERY_CAPTURE_MODE = ALL,\r\n    SIZE_BASED_CLEANUP_MODE = AUTO,\r\n    MAX_PLANS_PER_QUERY = 200\r\n)\r\n\r\n-- Query to find regressed queries\r\nSELECT \r\n    q.query_id, \r\n    qt.query_text_id, \r\n    qt.query_sql_text, \r\n    rs.runtime_stats_id,\r\n    rsi.start_time,\r\n    rsi.end_time,\r\n    rs.avg_duration\r\nFROM sys.query_store_query_text AS qt\r\nJOIN sys.query_store_query AS q\r\n    ON qt.query_text_id = q.query_text_id\r\nJOIN sys.query_store_plan AS p\r\n    ON q.query_id = p.query_id\r\nJOIN sys.query_store_runtime_stats AS rs\r\n    ON p.plan_id = rs.plan_id\r\nJOIN sys.query_store_runtime_stats_interval AS rsi\r\n    ON rsi.runtime_stats_interval_id = rs.runtime_stats_interval_id\r\nWHERE rs.avg_duration > 1000  -- 1 second\r\nORDER BY rs.avg_duration DESC;<\/code><\/pre>\n
[\/vc_column_text][\/vc_column][\/vc_row][vc_row el_class=”blog-detail-section”][vc_column][vc_column_text]<\/p>\n
5. \u7ed3\u8bba\u548c\u672a\u6765\u5c55\u671b<\/h2>\n
\u6b63\u5982\u6211\u4eec\u6240\u63a2\u8ba8\u7684,SQL Server\u4e3a\u4f18\u5316\u548c\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u63d0\u4f9b\u4e86\u4e30\u5bcc\u7684\u9ad8\u7ea7\u529f\u80fd\u3002\u4ece\u786e\u4fdd\u9ad8\u53ef\u7528\u6027\u548c\u65e0\u7f1d\u6570\u636e\u8fc1\u79fb\u5230\u521b\u5efa\u52a8\u6001\u62a5\u8868\u548c\u5b9e\u65bd\u5f3a\u5927\u7684\u76d1\u63a7\u89e3\u51b3\u65b9\u6848,\u8fd9\u4e9b\u6280\u672f\u4f7f\u6570\u636e\u5e93\u7ba1\u7406\u5458\u548c\u5f00\u53d1\u4eba\u5458\u80fd\u591f\u6784\u5efa\u53ef\u6269\u5c55\u3001\u9ad8\u6548\u548c\u53ef\u9760\u7684\u6570\u636e\u5e93\u7cfb\u7edf\u3002<\/p>\n
\u5c55\u671b\u672a\u6765,SQL Server\u7684\u524d\u666f\u4e0e\u4e91\u6280\u672f\u548c\u4eba\u5de5\u667a\u80fd\u5bc6\u5207\u76f8\u5173\u3002\u6211\u4eec\u53ef\u4ee5\u671f\u5f85\u770b\u5230\u66f4\u591a\u4e0eAzure\u670d\u52a1\u7684\u96c6\u6210\u3001\u6570\u636e\u5e93\u5f15\u64ce\u5185\u589e\u5f3a\u7684\u673a\u5668\u5b66\u4e60\u529f\u80fd,\u4ee5\u53ca\u7528\u4e8e\u7ba1\u7406\u6df7\u5408\u4e91\u73af\u5883\u7684\u6539\u8fdb\u5de5\u5177\u3002\u968f\u7740\u6570\u636e\u91cf\u7684\u6301\u7eed\u589e\u957f,\u5217\u5b58\u50a8\u7d22\u5f15\u548c\u5185\u5b58\u4e2dOLTP\u7b49\u6280\u672f\u5c06\u53d8\u5f97\u66f4\u52a0\u5173\u952e,\u4ee5\u4fdd\u6301\u5927\u89c4\u6a21\u6027\u80fd\u3002<\/p>\n
\u4e3a\u4e86\u5728\u8fd9\u4e2a\u5feb\u901f\u53d1\u5c55\u7684\u9886\u57df\u4fdd\u6301\u9886\u5148\u5730\u4f4d,\u6570\u636e\u5e93\u4e13\u4e1a\u4eba\u5458\u5e94\u8be5\u5173\u6ce8:<\/p>\n