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

?????? ????????? ?????? ?????????
???? ???????: 961323 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 50003879 (??????? ?????? SQL)
Microsoft ?????? ????????? Microsoft SQL Server 2008 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????.
????? ???? | ?? ????

???????

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

????? ?????? ??? ??????? ?? ???? ????? ???????? ???????.
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 ??? ???:
??? @ media_set_id = media_set_id ?? msdb.dbo.backupmediaset ??? 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 = media_count ?? msdb.dbo.backupmediafamily ??? media_set_id = @ media_set_id ? family_sequence_number = 1
???? ??? ???????? ?????? ??????? "?" ?????? ??????? ??? ??????? ??????? ????? ????????? msdb.

?????

????? ??? ????? ??????? ?????? ??????? ??? ??? ?????? ????? ????????? ?? ?????? ??????? ??? ?? ??????? ??????. ???? ?? ?? ???? ????? ???? ?? ????? ??????? ?????? ????? ????? ?????????.

????

?? ????? ??????? ????? ???? ??????? ????? ?? 3 ??????? ????????. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ?? SQL Server 2008 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
960484???? ??????? ???????? 3 SQL Server 2008
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
956909???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008

?????

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

??????? ????

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

?????

?????? ??? ???? ?? ????????? ??? ??????? ????????? ???? ????? ??? ????? SQL Server 2008 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
956909???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008
????? ?? ????????? ??? "????? ????? ??????" ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
935897????? "????? ????? ??????" ?? ???? SQL Server ?????? ????????? ??????? ??????? ?? ??????? ????
????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 961323 - ????? ??? ??????: 22/????/1430 - ??????: 1.0
????? ???
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Workgroup
????? ??????: 
kbmt kbsurveynew kbhotfixrollup kbfix kbpubtypekc kbqfe kbexpertiseadvanced kbhotfixserver KB961323 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????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