none
sys.dm_exec_cached_plans SUM(size_in_bytes) ERROR RRS feed

 > 

  • 问题

  • Question
    登录进行投票
    0
    登录进行投票

    My datebase version is SQL SERVER 2008 R2. I want to execute SQL( Select SUM(usecounts),SUM(CAST(size_in_bytes AS int)) From sys.dm_exec_cached_plans ) , But The SSMS clue to me,"消息 8115，级别 16，状态 2，第 1 行
    将 expression 转换为数据类型 int 时出现算术溢出错误。"

    And I change another DB SERVER(the same version about SQL SERVER), that SQL is right.

    IS the server memory have a mistake?

    Help ME~~~~!

    2011年10月28日 4:07
    |

答案