I have just create a new database server (intel Xenon E5620 2.4 Ghz * 2 processors) with win server 2008 R2 standard 64 bit.
i have just installed sql server 2008 Stranded 64 bit and copied a development database in it to test.
Server is having 8 GB RAM and out of this 7.5 GB is used by sqlsrvr.exe without any load and 0% CPU usage.
why this happens ?
what will be happen when i make this server live ? there are at least 600 users will work on this server, will this work or not ?
my older server is having 4 GB RAM and sql 2000, it is working using 1.91 GB RAM. New server is much more better then older one.