Any documentation regarding this causing that behavior?

Thanks

Vedran Kesegic (1/12/2013)

---

This should not spike your CPU:

SELECT count(*) FROM sys.dm_tran_locks WITH(NOLOCK)

Run it on both machines and compare the numbers. Almost idle system is a very different situation than a...

Vedran Kesegic (1/11/2013)

---

How many of this 12 000 connections is active (actually executing something, not just sitting there opened)?

How many NUMA nodes that machine have? Did you messed with CPU...

anthony.green (1/11/2013)

---

I would completly re-write it all, for one all the tables used are depreciated and are in the product for SQL 2000 compatability only, you really should be using...

I posted two SQLPlans one for the server with the spike and the other sql for server that is...

Bhuvnesh (1/10/2013)

---

APA0876 (1/10/2013)

---

there is a SQL Query that is causing 90% of CPU on one of the SQL servers also it run in 14 seconds, on other server with similar...

How can I send the execution plan on an xml format?

Thanks

I have done this but I can't install the analysis services over cluster instance:

because of the following error:

Rule "Existing clustered or cluster-prepared instance" failed

The instance selected for installation is already...

Hi, this instance is an old production Box, so we do not want the jobs to execute accidentally as we did not disable them before we stop the agent so...

Thanks

Yes, That is what I exactly want.

What I meant was - Install Oracle client driver to be able to create a linked server using an a system DSN previously...

Hi

Thanks for all the help!!!, this migration will be a success thanks to your advise

I have another question and it is related to the IPs, if I want to...

Thanks Again,

in the case of the default instance, then it will look like this:

OriginalVirtualNetworkName

TemporaryVirtualNetworkName

In the case of the Named Instance:

OriginalVirtualNetworkName\InstanceName

TemporaryVirtualNetworkName\InstanceName

Before the migration of course.

Thanks

Hi,

Thanks that's what we are planning - an upgrade to sql 2008 r2 keeping the same sql instance name to make this migration transparent to applications.

when you say create the...

As this is a cluster it will need to be the Virtual network name. This is a named instance which have this format:

Networkname\instancename

the new name will be:

NewNetworkname\instancename or should...