Viewing 15 posts - 481 through 495 (of 2,840 total)
WayneS (7/27/2011)
Roy Ernest (7/27/2011)
Not much traffic on my blog I am afraid. Or else I would have written it already.. 🙂Where is your blog?
Here in SSC. I just blogged about...
July 27, 2011 at 12:37 pm
Not much traffic on my blog I am afraid. Or else I would have written it already.. 🙂
July 27, 2011 at 11:37 am
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. 🙂
July 27, 2011 at 9:52 am
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...
July 27, 2011 at 9:08 am
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,...
July 27, 2011 at 9:05 am
I have seen others having the same problem. This what they did.
July 27, 2011 at 8:56 am
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...
July 26, 2011 at 3:12 pm
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...
July 26, 2011 at 2:31 pm
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...
July 26, 2011 at 2:22 pm
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...
July 26, 2011 at 1:56 pm
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...
July 26, 2011 at 1:35 pm
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...
July 26, 2011 at 12:29 pm
Could someone please gie some advice when you get time here?
July 26, 2011 at 11:49 am
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...
July 26, 2011 at 9:45 am
As far as I know, SQL Server Express functions only as a Subscriber.
July 26, 2011 at 9:30 am
Viewing 15 posts - 481 through 495 (of 2,840 total)