Download and read the whitepaper.

You may end up having to run profiler in order to find the problem query.

The whitepaper outlines some of the key things you'd want to include...

obrieste (8/28/2009)

---

Has anyone experienced any sudden spikes in Memory use where running analysis server 2005 using Windows 2003 on VMWare gsx server .

This is happening daily and the logs provide...

Another vote for VPC. I assume you only care about 32 bit.

Also note the RAM and external USB comments. Disk can be a bottlneck.

If your .vhd is on a USB...

I have a prime example with one requirement where a spreadsheet is required for each of our products, but each product has subproducts, and they're expecting to see upwards of...

You might also need to check with your AS400 administrator.

Could be a permission issue on that end.

Greg E

SQL Browser service uses port 1434

Greg E

In my startup log, the mssqlsystemresource file is started.

The next line lists the build version - I'm on 9.00.3310.

I don't see a listing in yours.

Does this file exist? And do...

Looks like they already tried that.

But a rather unusual looking IP address. 192.1681.

Greg E

Under IP Address tab here are the settings:

IP1

Active: Yes

Enabled: Yes

IP Address: 192.1681.1.64TCP Dynamic Ports:

TCP Port: 1433

IP2

Active: Yes

Enabled: Yes

IP Address: 127.0.0.1

TCP Dynamic Ports:

TCP Port: 1433

IP All

TCP Dynamic Ports:

TCP...

GilaMonster (8/13/2009)

---

Can't help much, but root cause is that some other app's listening on the SQL port. Only one app can listen on a port at a time (AFAIK). First...

not exists

(

select 'Nothing'

from Orders

...

Also take a look at this.

http://blogs.technet.com/claudia_silva/archive/2009/06/04/sql-server-performance-analysis-part-v.aspx

Describing exactly what was done to turn off hyper threading might give some clues, as well as why we decided to do this to begin...

You haven't given many details, and there could be any number of things causing your problem.

Most people take a quick peek in profiler to see if anything unusual sticks out.

Just...

Looks like you found something that 'worked great in test' but failed to scale to the real world.

The assumption of unlimited resources never seems to work out too well.

Great job,...

I'll have to do a little more pre / post SP testing than I thought. Sounds like nothing was determined for sure. We have a little room in our nightly...