Here in SSC. I just blogged about...

Not much traffic on my blog I am afraid. Or else I would have written it already.. 🙂

Change of topic, When will we know who won the Exceptional DBA of the Year Award? I just want to know if the Santa will be there this year. 🙂

What is your disk configuration? Where does the Log and Data file reside? By increasing the memory, it might give you a small respite to the sluggishness of the server...

Just one note to Chandan has specified. The distributor should be the same or higher version than that of the Publisher.

When registering the SQL 2008 on your Enterprise manager,...

I have seen others having the same problem. This what they did.

Thx for all the input. I appreciate it very much. I have two action points from this.

I will have to look at the missing indexes and I also know...

Now here is one of the reason why I raised the question of MAXDOP. I never did like the idea of giving MAXDOP 1 on the server level. At least...

The server is running OK. No hiccups yet. 🙂 Touch wood. More details regarding the system.

Cache Hit ratios

Buffer 100%, Plan(SQL) 55%, Plan (Objects) 100%.

No IO Waits (Very less).

The...

I thought I edited it properly. But I guess not.

wait_typewait_time_spct

CXPACKET18468243.6357.72

LATCH_EX3802397.9311.88

CMEMTHREAD1516464.844.74

SOS_SCHEDULER_YIELD1508456.114.71

ASYNC_NETWORK_IO1172668.813.67

MSQL_XP916031.632.86

PREEMPTIVE_OS_GETPROCADDRESS915633.182.86

OLEDB646687.822.02

TRACEWRITE641578.032.01

BACKUPBUFFER381806.381.19

Your Second query ran in 19 min.

Weigthed_Avg_DOPWeigthed_Avg_SubTreeCost

NULL17.060217

Total of 117 rows. Two out of the 117 has timeout as the reason...

Your second query is still running. But your first query here is the output.

counterfinal cost

occurrence 3189815

AvgValue2.77

namecost threshold for parallelism

config_value5

run_value5

Days Server UPTIME & Last Stats Reset167.50

Stats WarningNULL

Cost Threshold WarningNULL

Restart Warning NULL

And...

This is on an existing Hardware. When we moved into this server, we had two queries that was having parallel plan. I gave hint for just those two. During the...

Could someone please gie some advice when you get time here?

I have heard of of people using some hacks to get it to work. But I have never tried it. You might have to use RMO and Windows synchronization method...

As far as I know, SQL Server Express functions only as a Subscriber.