我有一台 SQL 服务器,但硬件出现故障。作为解决方案,我们在多核(较新)服务器上恢复了服务器映像。问题是,如果 CPU 数量不是 2 的幂,则无法启动 SQL 2000。我发现了文章这帮助我找到了一个很好的技巧来成功加载 SQL,但报告服务也遇到了同样的问题。
因此,我正在寻找如何在这个新硬件上加载 Reporting Services 的解决方案。这是 Report Server Service 的日志。
<Header>
<Product>Microsoft SQL Server Reporting Services Version 8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>SA Western Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerService__06_05_2014_13_45_41.log</Path>
<SystemName>S*******R</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
ReportingServicesService!servicecontroller!e24!6/5/2014-13:45:41:: Error Starting Service: System.ArgumentException: Value does not fall within the expected range.
at Microsoft.ReportingServices.Diagnostics.ResourceUtilities.BitsSet(Int32 nr)
at Microsoft.ReportingServices.Diagnostics.ResourceUtilities.ThrottleCpu()
at Microsoft.ReportingServices.Diagnostics.Globals.InitializeProcessParameters()
at Microsoft.ReportingServices.Library.ServiceController.StartService()
答案1
我能够使用基于 HP ROM 的实用程序解决选择服务器上核心数量的问题。我没有使用每个 CPU 的所有 12 个核心(总共 24 个),而是将每个 CPU 降级为 8 个核心,总共 16 个核心。由于它是 2 的幂,所以问题解决了。谢谢!