OK, SP2 has not helped in the least...

Any suggestions?

Yes, SQL Server 2005 can handle that much memory. However the base OS will still be your bottleneck. I believe it is, Standard OS is only 4GBs and Enterprise OS...

Forgot, SQL Server is als set to SIMPLE recovery in both environments. On the server, the t logs, data files, and tempdb are all on separate drives. RAID1, RAID 5,...

A very simplified version.

Text, EventClass, Duration, CPU, Reads, Writes - information shown. Nice and simple.

Ok, well timing for this is not that big an issue really. The view is rather complex and a I have said they will be removed shortly.

The thing is...

Nice and simple version of profiler. Without having to open up a separate application and so on. Profile session dedicated to your current session/SPID.

Just saves the hassle of having...

CXPACKET 135165 3.150802E+07 186078

Running the query with "OPTION (MAXDOP 1)". Currently no SUSPENDED SPIDs, but is still taking a lot longer than it does in SQL2000.

Lets see how that goes...

For those looking...

http://support.microsoft.com/default.aspx/kb/899761

SQL Server 2000 (32-bit)

SP4 - no hotfixes

Version - Microsoft SQL Server  2000 - 8.00.2039

What hotfix? Do you have Fix number, or link for me please?

Thanks!

Sorry for dragging up an old post.

I am stuck with the same issue, trying to get SQL to use more than 8GBs of RAM.

OS - Windows 2003 Advanced Server

SQL...

I do currently monitor all the other things, disk queue hardly gets to 2 on a 3 disk RAID5.

Memory is an issue, as we currently have Page Life Expectancy...

Thanks for the response...

Strange request I know, and I have already told my boss that he is out of his mind, if he expects me to come back with...

We are looking at Log shipping now, the problem is that I have only just gotten the change over from SIMPLE to FULL recovery model.

The full restore is a...

So does that mean that SQL Services do not need to be restarted?

Graham