How much do "Table Views" affect server performance on a whole?

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?

How much do "Table Views" affect server performance on a whole?

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?

How grant all objects

How
grant user to tables(insert,update,delete,select),Sp,Func,Views !
in one line...
if can be...You'll need to do updates to the system tables, (I believe) and so you'll need to allow ad-hoc updates on those tables - normally not allowed.

However, and I know this is not what you're asking, but I like not giving any permissions on tables, and only giving exec permissions on Stored Procs. This way you protect your tables and you limit what can be done / seen in your database by defining allowed requests and actions in the procedures.