November 10, 2008 at 2:24 am
On one of our servers, we have 2 instances of SQL Server 2005,
I.e. An instance for our databases, and an instance created and used by a backup utility (Backup Exec).
The way that the server was set up, the backup utility was installed first,
making our database instance MSSQL.2.
My question is, does anyone know whether SQL Server prioritizes any particular instance,
and would we see an improvement in performance if we removed both instances,
and reinstalled so our databases use the first instance?
Thanks.
November 10, 2008 at 2:54 am
You can prioritize a SQL instance, by enabling the server setting "Priority Boost" (server properties->Processors), but this could lead to other problems (like network problems), because in some cases, SQL is eating to much resources.
What you also can do is alter the number of processors for each instance (same property sheet), I.e just one processor for the backup and the rest for your production environment. Same for Memory Options. NOTE: if you have more than 1 instance, make sure these instances are not competing for memory by defining minimum and maximum memory for each instance.
Assuming you don't have Priority Boost enabled and both instances can use all CPUs, Windows is balancing these instances depending on the workload.
Wilfred
The best things in life are the simple things
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply