?????: ??? ????? ???? ????? ??? ???? SQL Server ?? SQL Server 2008 R2

?????? ????????? ?????? ?????????
???? ???????: 2587511 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???? Microsoft ?????? ????????? Microsoft SQL Server 2008 R2 Service Pack 1 (SP1) ???? ???? ???? ???????. ??? ???????? ?????????, ?? ????? ???? ????? ??? ???? ????????? ??????? ????? ????????? ??????? ???? ?? ??????? ?? ????? SQL Server 2008 R2 Service Pack 1 (SP1) ??????? ??????.

???????

????? ???? ????? ??? ???? ???? SQL ?? Microsoft SQL Server 2008 R2? ?? ????? ????? ????? ???????:
Msg 512? ????? 16, 1? ???? sp_sqlagent_get_perf_counters ???????? 40 ??
??????? ???? ?????? ???? ???? ?? 1. ??? ?? ??? ????? ?? ????? ???? ????????? ?????? =?! =? <,> </,> <= ,="">?> = ?? ??? ??????? ????????? ?????? ??????.</=>
???????? ??? ???? ??? ????? ????? ??????? ?????? ?? ??? ????? SQL Server ???? ?? ??? ??????.

?????? ???? ??? ??????? ???? ?? Microsoft SQL Server 2008.

?????

???? ??? ??????? ????? ????????? ?????? msdb.dbo.sp_sqlagent_get_perf_counters ???? ???? ???? ????? ?????? ?????? ???? ??? ????.

????????? ?????? ????? ??? ????? ??? ?????? [??? _ ??????] ???? ?? ???? ????????? ??????. ????? ??? ????? ???? ?????? ???? ??? ????? ????? ??????? ???????? ?? ??? "???????".

?????? ????? msdb.dbo.sp_sqlagent_get_perf_counters ????? ???? ????? ??????? ????? ???? ????? ??? ???? ???? SQL.

????

??????? ??????? ????????

???? ??????? ????????? 3 ? SQL Server 2008 R2 SP1

???? ????? ??????? ????? ???? ??????? ?? ???? ??????? ????????? 3. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ????????? ? SQL Server 2008 R2 SP1? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2591748 ???? ??????? ????????? 3 ? SQL Server 2008 R2 SP1
?????? ????? ???? ??????? ???????? ????? ?? ????? ??????? ?????? ??? ???? ????????? ??????? ????? ????????? ??????? ???? ?? ??????? ?? ?????? SQL Server 2008 R2 SP1 ????? ???????. ???? ??????? ????? ???? ?? ????? ??????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2567616 ???? SQL Server 2008 R2 ???? ?? ??????? ??? ????? SQL Server 2008 R2 SP1


???? ??????

?????? ??? ??? ???????? ?? ?????? ????????? ?????? msdb.dbo.sp_sqlagent_get_perf_counters ????? ???? ??????. ?????? ????? ?? ?????? ??? ??????? ??? ????? ?? ??????????? ??????? ??????? ???? ??? ????????? ?? [????] ???? ??????:
(spi1.[object_name] = spi2.[object_name])
??? ????? ?????? ??????????? ??????? ??? ???:
SELECT CASE spi2.cntr_value WHEN 0 THEN 1 ELSE spi2.cntr_value END
FROM sys.dm_os_performance_counters spi2
WHERE (spi1.[object_name] = spi2.[object_name])
AND (spi1.counter_name + ' ' = SUBSTRING(spi2.counter_name, 1, PATINDEX('% Base%', spi2.counter_name)))
AND (spi1.instance_name = spi2.instance_name)
AND (spi2.cntr_type = @perfTypeLargeRawBase

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

???????

???? ???????: 2587511 - ????? ??? ??????: 19/?? ??????/1432 - ??????: 1.0
????? ???
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Enterprise Evaluation
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
????? ??????: 
kbqfe kbfix kbexpertiseadvanced kbsurveynew kbmt KB2587511 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????2587511

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com