update statistics slowing system
Should doing an update statistics on a table in one database affect the preformance of users in a totally separate database. Does it lock some global tables? I don't think it is a CPU problem since this is on a 6 processor Linux system.
↪ replying to Glen Johnson
On Wed, 12 Nov 2003 20:10:19 GMT, "Glen Johnson" <glen@csisoft.com> wrote: >Should doing an update statistics on a table in one database affect the >preformance of users in a totally separate database. Does it lock some >global tables? I don't think it is a CPU problem since this is on a 6 >processor Linux system. > No, but disk access may be a bit of an issue . . . .