What entries are in the server network utility?

Tom

What is the startup account being used for sql server.  Are they the same on both servers?  Are they both in the same domain.  Do you map the user to...

I setup linked servers to our production as400/db400 databases.  I use the i-series access odbc driver with a odbc linked server.  I four part name my way to all of...

Have you tried running the query through query analyzer and not through the program?  What was your performance? 

I have seen query's go from 1 sec to 20 min overnight...

Is there an index on the data.  Run dbcc showcontig on the table to see if your table is overly fragmented.  If you are doing a lot of inserts/deletes into...

Are you running the profiler client on the server or on the server?  Are you logging it to a database?  Did you set it up to just look at one...

How big can your database grow.  Is autogrow on.  Is there freespace in the datafile.  It sounds like your database is autogrowing the datafile and the application is timing out...

dbcc showconitg will also show you how fragmented the indexes are and could point out potential performance issues.

Tom

You can use profiler to log the users activities.

Tom

The following select will let you know which files are in your database.

select * from sysfiles

You can use the alter database to remove the extra log file.  You have to...

I got sp_lock2 from the microsoft support site.

I would monitor it all the time and see what processes/users are creating and using tempdb that much.

Tom

Kathi,

Sp_lock will tell you the locks present in your databases including tempdb.  There is another sp called sp_lock2 (I think I got it from microsoft) it is essentially the same...

I've tested changing the sort orders of my indexes and never saw any performance gains with them.  As long as you have the join field indexed it should be doing...

You could check to see if you are calling any sp_oa stored procedures by querying the text column in syscomments.

You only have 1 gig of memory and Sql is a...

If the log was that big before you started doing your backups then without doing a shrink it will stay that size and not grow anymore.

DBCC SQLPERF (LOGSPACE) will tell...