g*l
2 楼
我有一个JOB是RENAME一个很大的TABLE,然后用一个空的TABLE,替换出来了好ARCHIVE
,一些BCP之类的东西,因为数据很多,又不能DELETE,TRUNCATE又怕丢失数据,一天1.
4MILLION.所以只能RENAME,RECOMPLILE,之后还做了UPDATE STATISTICS
(当然可以用PARTITION做ARCHIVE,但现在不是2008 COMPATIBLE,不能用TABLE
PARTITION),现在问题是这个JOB RUN完MAX I/O WAIT就上去了,
我测了一下WRITES TO TEMPDB DOUBLE了,大家看是什么问题,现在MAX I/O在三位数,
周一没RUN这个JOB的时候在两位数,TEMPDB现在自己一个RAID 1.
,一些BCP之类的东西,因为数据很多,又不能DELETE,TRUNCATE又怕丢失数据,一天1.
4MILLION.所以只能RENAME,RECOMPLILE,之后还做了UPDATE STATISTICS
(当然可以用PARTITION做ARCHIVE,但现在不是2008 COMPATIBLE,不能用TABLE
PARTITION),现在问题是这个JOB RUN完MAX I/O WAIT就上去了,
我测了一下WRITES TO TEMPDB DOUBLE了,大家看是什么问题,现在MAX I/O在三位数,
周一没RUN这个JOB的时候在两位数,TEMPDB现在自己一个RAID 1.
g*l
4 楼
自问自答,经过一分析,BUFFER CACHE可能有一个OLD QUERY PLAN,所以有使用很频繁
的SP老是RECOMPILE,造成WRITES偏高。解决办法是,ARCHIVE之后把DBCC把BUFFER
CACHE和SP CACHE清空,强迫系统重新COMPILE.因为是PRODUCTION现在不敢TEST,再等
一等。
的SP老是RECOMPILE,造成WRITES偏高。解决办法是,ARCHIVE之后把DBCC把BUFFER
CACHE和SP CACHE清空,强迫系统重新COMPILE.因为是PRODUCTION现在不敢TEST,再等
一等。
g*l
6 楼
汇报一下,TEMPDB移走,单独一个RAID 1,16CORE,8个TEMPDB FILES。一样大小和
AUTO GROWTH,I/O WAIT基本解决了,另外ARCHIVE JOB之后加了DBCC FREE CACHE,估
计明天HIGH IO WAIT的问题可以彻底解决了
AUTO GROWTH,I/O WAIT基本解决了,另外ARCHIVE JOB之后加了DBCC FREE CACHE,估
计明天HIGH IO WAIT的问题可以彻底解决了
g*e
7 楼
多大一棵?白兰确实比较贵
i*e
8 楼
胡扯去吧, 这东西都是美国就已经有苗圃可以培育的了, 什么进口,满嘴跑火车。
m*z
15 楼
no pic?
g*e
16 楼
白兰这种很难养护的花最好从小树入手,万一养不好学费不至于太昂贵。
c*p
23 楼
贵了,大森5加仑的,大概1.5米高的卖45好像
G*9
29 楼
Where are you?
I am in DC area and I did well on reproducing gardenia.
If you are in DC area, I can teach you all the tricks.
I am curious where to get 4 different varieties. :) Could you enlighten me?
Thanks.
to
【在 b*****s 的大作中提到】
: how to 繁殖栀子花?
: I have 4 big 栀子花 plants ( different varieties). always wondering how to
: make more of them without buying.
I am in DC area and I did well on reproducing gardenia.
If you are in DC area, I can teach you all the tricks.
I am curious where to get 4 different varieties. :) Could you enlighten me?
Thanks.
to
【在 b*****s 的大作中提到】
: how to 繁殖栀子花?
: I have 4 big 栀子花 plants ( different varieties). always wondering how to
: make more of them without buying.
s*y
32 楼
呵呵,大家说的我还挺后悔的,主要怕养死了就太心疼了。我在湾区,这边的物价比LA
的贵一些,不过总之那个店主还是挺黑心的。我知道离我们这儿开车40分钟的一个苗圃
卖白兰花,还有金桂,虎头茉莉等等。准备去看看,顺便比较一下价钱。
的贵一些,不过总之那个店主还是挺黑心的。我知道离我们这儿开车40分钟的一个苗圃
卖白兰花,还有金桂,虎头茉莉等等。准备去看看,顺便比较一下价钱。
b*s
35 楼
I am in San Fransicsco bay area.
maybe you can share some of your tips on reproducing gardenia.
I have 4 different speicies, leafs, flower, size, blooming period are
different. the smell are same.
the youngest is a small leaf gardenia ( gardenia radica spell? ), it is very
low growing , 2 feet height, more than 4 feet wide.
the other 3 are big leaf variety, 1 grows very tall, around 6 feet. the
other are around 3-4 feet tall. one of them even have flowers in winters
here in bayarea.
you can see different varieties here.
http://baike.baidu.com/view/4564.htm
?
【在 G*******9 的大作中提到】
: Where are you?
: I am in DC area and I did well on reproducing gardenia.
: If you are in DC area, I can teach you all the tricks.
: I am curious where to get 4 different varieties. :) Could you enlighten me?
: Thanks.
:
: to
maybe you can share some of your tips on reproducing gardenia.
I have 4 different speicies, leafs, flower, size, blooming period are
different. the smell are same.
the youngest is a small leaf gardenia ( gardenia radica spell? ), it is very
low growing , 2 feet height, more than 4 feet wide.
the other 3 are big leaf variety, 1 grows very tall, around 6 feet. the
other are around 3-4 feet tall. one of them even have flowers in winters
here in bayarea.
you can see different varieties here.
http://baike.baidu.com/view/4564.htm
?
【在 G*******9 的大作中提到】
: Where are you?
: I am in DC area and I did well on reproducing gardenia.
: If you are in DC area, I can teach you all the tricks.
: I am curious where to get 4 different varieties. :) Could you enlighten me?
: Thanks.
:
: to
相关阅读
Why is EXISTS generally faster than IN clause?any tool to load xml file into oracle?summary data by category in ArcGis如何在oci中运行sql script?SQL-Server2k与XP是不是有兼容性问题啊[转载] strong SQL skills?关于存储计算的问题,请解答Access 用户权限设置的疑问how to make this query请教一个sql问题Organic chemistry Web问关于group by的问题问一个excel的弱问题Help: "Operation Must Be Updatable Query"mysql or sqlserver?5100Access HistoryHow to add a blank column in a Query?Please help: Innodb table could not drop a columndatabase exception