We have a database on a server that is having performance issues, and a mont
h into investigating I'm not finding anything different from our other serve
rs (we even upgraded the hardware). However, there is a database with 47 Ta
ble Views, that I am 99% su
re gets data into it constantly. Is it possible that the ludicrous number o
f Tabel Views set up are affecting normal server performance?By "Table Views", do you mean standard Views? The number of views should not
impact performance. If data is constantly being inserted, then you may want
to look at removing any indicies that are not needed as these can slow perf
ormance. Consider periodica
lly rebuilding indicies and updating database statistics as well, as both of
these can impact performance.
Steve
-- Stephen M Accetta wrote: --
We have a database on a server that is having performance issues, and a mont
h into investigating I'm not finding anything different from our other serve
rs (we even upgraded the hardware). However, there is a database with 47 Ta
ble Views, that I am 9
9% sure gets data into it constantly. Is it possible that the ludicrous num
ber of Tabel Views set up are affecting normal server performance?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment