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

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

?? ????? ??

Microsoft ?? ????? ????? ?? ??? ??? Microsoft SQL Server 2008 R2 ?????? ??? 1 (SP1) ?????? ?????? ???? ??? ??????? ????? ???? ???, ????? ???????? ?? ?????? ??? ?????????? ?? ????? SQL Server 2008 R2 ?????? ??? 1 (SP1) ?????? ?????? ?? ??? ????? ??? ?? ??? ??????? ?????? ???

?????

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

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

????

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

Subquery ?? ??? ????? ?????? ????? ?? ???? ???? ?? [object_name] ????? subquery ?? ?????? ???? ?????, ?? ?? ???? ????????? ???? ??? ?? ??? ?? ???, ?? ?? "?????" ??? ??? ?????? ?????? ??????? ???? ???

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

????????

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

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

?? ?????? ?? ??? ????? ????? ?????? ????? 3 ???? ?????? ???? ??? ??? ?? ????? ?????? ?????? SQL Server 2008 R2 SP1 ?? ??? ??????? ???? ?? ????? ?? ???? ??? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2591748 SQL Server 2008 R2 SP1 ?? ??? ????? ?????? ????? 3
??? Builds ????? ???? ???, ????? ??? ?????????? ?? ?? ?????? ???? ?? ?? ????? SQL Server 2008 R2 SP1 ?? ??? ????? ??? ?? ??? ??????? ?????? ?? ?????? ??????? ?? ??????? ???? ??? ?? ?? ???? ?? ??? ?? ?????? ?? ???????? ????? ?????? ?????? ?????? ?????? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2567616 SQL Server 2008 R2 SP1 ?? ?????? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ?? ?? SQL Server 2008 R2


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

?? ?????? ?? ???????? ?? ?? ???, subquery ?? ?????? ???? msdb.dbo.sp_sqlagent_get_perf_counters ???????? ????????? ??????? ??? ???? ?? ???, ?????????? ???? ???? ?? ??? ??????. ???? ??????? ?? ??? subqueries ??? ???????? [???] ????? ????:
(spi1.[object_name] = spi2.[object_name])
???? ?????? ?? ???, subqueries ?????????? ???? ???:
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 ???????? ??? ?? ?????? ???

???

???? ID: 2587511 - ????? ???????: 17 ??????? 2011 - ??????: 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 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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