| Author |
pinning ms_replcommands (dbcc pintable)
|
|
| combfilter 2005-07-19, 8:24 pm |
| Is this a good performance increase suggestion if disk I/O seems to be
an issue sometimes.
We are replicating some very busy tables across a wan. We have ram to
spare on our distributor. We thought about pinning the ms_replcommands
table to see if we could help disk i/o .
is this a good idea?
tia
-comb
| |
| seanbell68@gmail.com 2005-07-19, 8:24 pm |
| I doubt you would get any performance increase. Pinning the table would
allow it to stay in memory but fetching rows from ms_replcommands is
not likely to be the source of the I/O. Also, if you have enough memory
SQL Server does a good job of managing what data needs to be cached.
More memory in the server might be a better solution.
| |
| combfilter 2005-07-19, 8:24 pm |
| In article <1121808111.871451.41790@g49g2000cwa.googlegroups.com>,
seanbell68@gmail.com says...
> I doubt you would get any performance increase. Pinning the table would
> allow it to stay in memory but fetching rows from ms_replcommands is
> not likely to be the source of the I/O. Also, if you have enough memory
> SQL Server does a good job of managing what data needs to be cached.
> More memory in the server might be a better solution.
>
>
Thanks for the response. I hope a few more people throw in their two
cents on this. I need to present this back to them.
thx
-comb
| |
| Hilary Cotter 2005-07-20, 3:23 am |
| This is seldom a good idea.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"combfilter" <asdf@adsf.com> wrote in message
news:MPG. 1d47340be37d3d7a9896
ab@news.newsreader.com...
> In article <1121808111.871451.41790@g49g2000cwa.googlegroups.com>,
> seanbell68@gmail.com says...
> Thanks for the response. I hope a few more people throw in their two
> cents on this. I need to present this back to them.
>
> thx
> -comb
| |
| combfilter 2005-07-20, 11:23 am |
| In article <O1XvyTNjFHA.1480@TK2MSFTNGP10.phx.gbl>,
hilary.cotter@gmail.com says...
> This is seldom a good idea.
>
>
how come?
|
|
|
|