FIX: ????? ?????? ????? ?? gradually ?? ?? ????? ?? ??? ?? ???? ?? SQL Server 2008 ??? ???? ??????? ???????????? ????

???? ?????? ???? ??????
???? ID: 961323 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
Bug #: 50003879 (SQL ????????)
Microsoft ?? downloadable ???? ?? ??? ??? Microsoft SQL Server 2008 ??????? ?????? ???? ??? ??????? ????? ???? ???, ??????? ?? ?? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 ?? ??? ????? ?? ?? ??? ???? ???
??? ?? ??????? ???? | ??? ?? ??????? ????

?????

????? ?? ?? ????? ?? ??? ?? ???? ?? ???????????? Microsoft SQL Server 2008 ??? ???? ???????, ?????? ????? ?? gradually. ??? ??, ????????? ??? ?? ???? grows steady ?? ?? ???

????? ??? ?? ??? ?? ?? ?? ?????? ?? ??? ???? ????
SELECT p.plan_handle,
CONVERT (varchar, GETDATE(), 126) AS runtime, 
LEFT (p.cacheobjtype + ' (' + p.objtype + ')', 35) AS 
cacheobjtype,
p.usecounts, p.size_in_bytes / 1024 AS size_in_kb, 
stat.total_worker_time/1000 AS tot_cpu_ms, 
stat.total_elapsed_time/1000 AS tot_duration_ms, 
stat.total_physical_reads, 
stat.total_logical_writes, stat.total_logical_reads, 
LEFT (CASE WHEN pa.value=32767 THEN 'ResourceDb' 
ELSE ISNULL (DB_NAME (CONVERT (sysname, pa.value)), CONVERT 
(sysname,pa.value))
END, 40) AS dbname,
sql.objectid, 
CONVERT (nvarchar(50), CASE 
WHEN sql.objectid IS NULL THEN NULL 
ELSE REPLACE (REPLACE (sql.[text],CHAR(13), ' '), CHAR(10), '
')
END) AS procname, 
REPLACE (REPLACE (SUBSTRING (sql.[text], 
stat.statement_start_offset/2 + 1, 
CASE WHEN stat.statement_end_offset = -1 THEN LEN 
(CONVERT(nvarchar(max), sql.[text])) 
ELSE stat.statement_end_offset/2 - 
stat.statement_start_offset/2 + 1
END), CHAR(13), ' '), CHAR(10), ' ') AS stmt_text
FROM sys.dm_exec_cached_plans p 
OUTER APPLY sys.dm_exec_plan_attributes (p.plan_handle) pa 
INNER JOIN sys.dm_exec_query_stats stat ON p.plan_handle = 
stat.plan_handle 
OUTER APPLY sys.dm_exec_sql_text (p.plan_handle) AS sql
WHERE pa.attribute = 'dbid' 
ORDER BY p.plan_handle DESC
?????? ??? ?? ??? ???? ?? ?? ??? ?????? stmt_text ????? ?? ??? resemble ????? ?? ??????:
@ media_set_id ?? ??? ???? msdb.dbo.backupmediaset ?? media_set_id = ???? media_uuid = N ' {7C5DCC4D-3065-47F3-AA5F-2C498DFF27F8}

msdb.dbo.backupmediaset (media_uuid, media_family_count, software_name, software_vendor_id, MTF_major_version, mirror_count, is_password_protected, is_compressed) ???????? ???? (N '{7C5DCC4D-3065-47F3-AA5F-2C498DFF27F8}', 1, @ param0, 4608, 1, 1, 0, 1) ???

@ media_set_id ?? ??? ???? @@ ????? ?????? ?? ??? ???? @ media_count = msdb.dbo.backupmediafamily ?? media_count = ???? media_set_id @ media_set_id ?? family_sequence_number = = 1
?? ???????? ??? ???????? ?? ???? ???????? ?? ???? ?? ??? msdb ????? ?????? ???????? ????

????

??????? ????? ??? ?? ???????????? ??? ??? ???? ???? ??? parameterized ????????? ??? grows. ???????? ??? ??? ??? ???? reused ??? ??? ?? ?? prepared ??? ?????? ???

????????

?? ?????? ?? ????? ????? ?????? 3 ??? ???? ?????? ???? ??? ??? SQL Server 2008 ?? ??? ?? ????? ?????? ?????? ?? ??????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
960484SQL Server 2008 ?? ??? ????? ?????? ?????? 3
???:Builds ????? ???? ???, ??????? ?? ?? ????? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 ?? ??? ????? ?? ?? ??? ???? ??? ?? ??????? ???? ??? ?? ?? ????? ?????? ????? ?????? ?????? ?? ???????? ?? ???? ???? ?? ??? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
956909SQL Server 2008 SQL Server 2008 ?????? ???? ?? ??? ?????? ??? ?? ?? ????? ??

??????

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

???? ???????

???? ??????? ?? ????????? ???? ?? ???? ??? ???? ??????? ?? ???, ?? ???? ?? ??? ???? ?? ????? ?????? ?????? ?????? ?? Microsoft ???????? ???? ??? ?????? ???????? ?? ???? ???? ?? ???? ??? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
960484SQL Server 2008 ?? ??? ????? ?????? ?????? 3

??????

???? ??????? ?? ??? ???? ?? builds SQL Server 2008 ?? ?????? ???? ?? ??? ?????? ???, Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
956909SQL Server 2008 SQL Server 2008 ?????? ???? ?? ??? ?????? ??? ?? ?? ????? ??
???? ??????? ?? ??? ????????? Servicing ???? SQL ????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
935897?? ????????? Servicing ???? ?? SQL Server ??? ?? ??????? ?? ?? ???????? ?? ??? ?? ???????? ?? ?????? ???? ?? ??? ?????? ??
SQL ????? ?????? ?? ??? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
822499Microsoft SQL Server ?????????? ?????? ???????? ?? ??? ??? ?????? ??????
?????????? ?????? ???????? ?? ???? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
824684Microsoft ?????????? ???????? ?? ????? ???? ?? ??? ????? ?? ???? ???? ???? ???????? ?? ?????

???

???? ID: 961323 - ????? ???????: 06 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Workgroup
??????: 
kbsurveynew kbfix kbPubTypeKC kbqfe kbexpertiseadvanced kbHotfixServer kbmt KB961323 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:961323

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

 

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