Alone (11/12/2011)
I am not sure whether there in any memory issue but i can see SQL only using 13.8 GB memory constantly but i have configured max memory 20GB.
Ok, again, is that a problem? Are you seeing signs of memory pressure in SQL Server?
I was suggested if i can use sqlserver 2000 EE 64 bit the issue could be solved.
If you bought an Itanium server. SQL 2000 does not have an x64 version, only IA64. It's a completely different processor architecture and, as far as I know, they've been discontinued for a few years.
I can see daily 6/7 times temp blocking occurred.
Which may or maynot, but probably doesn't, have anything to do with memory. Blocking is often poor indexing or poor code.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability