You'll need to provide a bit more info.

Are you running again with same parameters?

Are the execution plans the same?

Is anything happening on that table (large updates/inserts/deletes) in between the two...

That was my initial thought, but then he says the COPY job has run successfully. So either the file is not there (possible to copy manually [if exists] - depending...

This may help you:

http://www.mssqltips.com/tip.asp?tip=2063

Personally i'd reconfigure for that DB and start again. Although somebody may post a solution that won't require that?

What version is the remote server? You're using SSMS 2008 right?

Can you ping the remote server and get a reply?

Check

the credentials you're using are correct,

the server will accept...

Personally i'd go with the 4 disk RAID5 for database files, and 2 disk RAID1 for OS and LogFiles. But as always...it comes down to "it depends"; load, usage etc

You can add fields to a table which is an article and part of a transactional publication, and the field will be applied to the subscriber. I don't think you...

Shouldn't he be using ".ndf" for his secondary files? I thought you could have only one ".mdf"?

Big big thanks to SSC for providing acces to these webinars. I find them to be of great benefit and always look forward to the next. 😀

Cheers

Nick

Thanks Jason, i just wanted to be sure I wasnt missing something on the aggregations from the exec_query_stats. Excellent 🙂

Partial Backup caught me out on this one, had the others. So there's a "learning opportunity" for me. 😉

You can get a lot out of the index DMV's

sys.dm_db_index_operational_stats

sys.dm_db_index_physical_stats

Although these are for showing locking information / fragmentation level etc, if you don't supply a databaseid (param 1) you'll get...

Excellent point. I think he did restart the service.

I would still advise running a trace to try and identify timeout issues, may not necessarily be a soley CPU issue.

SELECT TOP 50

SUM(QS.TOTAL_WORKER_TIME) AS TOTAL_CPU_TIME,

SUM(QS.EXECUTION_COUNT) AS TOTAL_EXECUTION_COUNT,

COUNT(*) AS NUMBER_OF_STATEMENTS,

SQL_TEXT.TEXT,

QS.PLAN_HANDLE

FROM SYS.DM_EXEC_QUERY_STATS QS

CROSS APPLY SYS.DM_EXEC_SQL_TEXT(SQL_HANDLE) AS SQL_TEXT

GROUP BY SQL_TEXT.TEXT,QS.PLAN_HANDLE ORDER

BY SUM(QS.TOTAL_WORKER_TIME) DESC

This query will show...

If this was an AdHoc query it may be difficult to spot. If this is caused from "normal" routine usage then I suggest you run a SQL Profiler trace and...