sys.dm_exec_cached_plans SUM(size_in_bytes) ERROR RRS feed

  • 问题

  • 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