Below query failed which executing in sql 2005 64Bit and large memory
select count(*) AS Buffered_Page_Count
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ,count(*) * 8192 / (1024 * 1024) as Buffer_Pool_MB
Msg 8115, Level 16, State 2, Line 4
Arithmetic overflow error converting expression to data type int.
but it work fine in my test server which running 2GB of ram with sql 2005
View Complete Post