I have 4Gb of RAM in the server, and I have 25CAL license. All internet users coming to DB throw IIS are using only one CAL. In my case they are using two CAL, because they are coming throw two load balancing servers.
I have to ask our programmers about indexing and way of access to tables. I'm looking on this from SysAdmin side.
100% CPU usage on DB server is done by a lot of users. 99% of the access to databases is coming from two web servers (IIS 5.0) (load balancing web pages).
There is 6 separate...
We are using SQL 2000 Enterprise Edition in the cluster (two servers plus shared storage). This question (about 4 or 8 CPU’s server) came when we realize that servers we are using now (Xeon 4x550Mhz) are in use for 100% CPU time nearly all the time. All Query are optimized by maximum (main...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.