thanks - after looking more closely i see why I missed it.  There are nulls in the filename field - so these traces are not being saved to a file. ...

Yes, the installer did want to create the entry in the dns.  Got it up and running.  Thanks for the help.

iwg - yes, our sp's and hotfixes are up to date

vineet - we identified a new query which was run in production on the days of the problem. We...

I've read that Total Server Memory is the amount that sql server has reserved and that it will hold on to that amount until another app requests it.  Can you...

Thanks for your help.

We've found several issues:

Our disks are heavily fragmented

There was a long running query which coincided with a few of the slow downs

The page file is set to...

more notes:

AWE is enabled in sql

PAE and  3GB switches are on in boot.ini

Some numbers:

Target Server Memory-kb:6270473

Available MBytes: 191

Pages/sec:.051

Free Pages: 54793

Buffer cache hit ratio: 99.8

Page Faults /sec: 213

Working set(sqlserver): 127750000

Disk Reads/sec:...

Lowell,

You sir, are much appreciated!

Thanks

Sam

You could check the sysobjects table in each database - look for xtype = U

Get this: http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

My current connection string is:

DRIVER={SQL Server};SERVER='ISERVER';UID=sql_dba_link;PWD=MyPwd;Initial Catalog=SQL_DBA

Where would I put the port information as seen below? from http://support.microsoft.com/kb/888228/en-us

[oledb]

; Hardcoded TCP OLE DB initstring

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=clientID;Data Source=tcp:TcpIpAddress,port

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops2.mspx

2a. You must make them use Perforce, otherwise, fire them.  But really,  a responsible dba or senior developer should be putting changes in.  They should check update/rollback scripts into...

Or use a case statement if there are not too many values.

Have you looked at the query execution plan?

Can you show us the result of @sql here:

IF @Debug = 1

            BEGIN

                        PRINT @sql PRINT ''

            END

Hi Lowell,

Thanks for your help. 

I'm guessing they are not able to print directly from the report due to the ActiveX control for printing not being installed.  I have the...

Thanks for your help gentlemen,

The server is not a named instance.

When executing a select I get this:

select * from MyLinkedServer.sql_dba.dbo.SQLDBA_ServerInfo

Server: Msg 7399, Level 16, State 1, Line 1

OLE DB provider...

I appreciate all the ideas. I've got to get something together quickly for a report on our environment, and I don't think I'm going to be able to work...