November 28, 2005 at 1:08 pm
It can when they are sharing the same physical resources. You say this server only has 40 GB of disk space. I would assume that this is all on a single 40 GB internal disk drive. This means that both databases are sharing CPU time, RAM, and disk. If the McAfee DB is being written to or read from quite often, your DB may be waiting for the McAfee disk read/write requests to be processed before SQL Server can process I/O for your DB. For optimal performance, each user database, the SQL Server databases, and the tempDB should have it's own physical disk or raid structure. Depending on what you find, you may want to recommend to your client that they offload their McAfee DB to another server or add resources to their small business server.
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply