We have a database on a server that is having performance issues, and a month into investigating I'm not finding anything different from our other servers (we even upgraded the hardware). However, there is a database with 47 Table Views, that I am 99% sure gets data into it constantly. Is it possible that the ludicrous number of 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 performance. Consider periodically rebuilding indicies and updating database statistics as well, as both of these can impact performance
Stev
-- Stephen M Accetta wrote: --
We have a database on a server that is having performance issues, and a month into investigating I'm not finding anything different from our other servers (we even upgraded the hardware). However, there is a database with 47 Table Views, that I am 99% sure gets data into it constantly. Is it possible that the ludicrous number of Tabel Views set up are affecting normal server performance?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment