No. I need that when I rdp into the server and run ssms there as well as for any processes that run local to the server.

Shared memory is disabled on the application servers. These are separate systems, so no local connections to the database servers. All connections from the application servers are using TCP.

We'll see soon enough. We move everything to the new hardware tomorrow and will be live by 5:00 PM.

paradox (pair o' docs)

We've disabled TCP Offloading on the SQL Server systems. Now it is a waiting game to see if the intermittent problem still occurs.

GilaMonster (3/5/2010)

---

Here you go

http://support.microsoft.com/kb/324270

On Server 2003 RTM, the setting for SynAttackProtect is 0. With SP1 it was changed to 1.

iirc, that's the one that we had to change back...

I find using google and the Microsoft Knowledge Base quite the same. It is an art to find what you are looking for quickly.

I'd spend hours looking in the...

Probably leaves me out, but not sure where HB is.

GilaMonster (3/5/2010)

---

Had same thing some time back. Turned out to be a side-effect of the anti-DoS features added in, i think, a service pack of Win server 2003. Details fail...

Data caching. The first time you run the query the data has to be pulled from disk. Subsequent queries for the same data pull from cache.

I'd be curious as well. Also, is this something that could be done remotely?

Fatal Exception Error (3/5/2010)

---

Chad Crawford (3/5/2010)

---

If it's the points you need - there are about a half dozen different ways to guarantee you get the QOD right every time,...

Jack,

Thanks. I have forwarded the info you provided to my PeopleSoft Admin and Network Services. We'll see what transpires and I'll keep everyone posted.

As to the second blog,...

You need to cast 1.8 as a float. See the following:

create table #temp (

column1 float

);

declare @TestVar float;

set @TestVar = 975.81;

insert into #temp select @TestVar;

select column1

...

Okay denizens, looking for ideas and suggestions here.

Thanks.