SQL Server 2000 with Indexed Views

Impact on performance?

[lorenzinho2]

Hi All, I'm thinking about upgrading to an enterprise license so that i can have access to indexed views capability.

My CPU is pretty much maxed out, site performance is suffering, and I'm hoping this will help.

Has anyone had experience upgrading to this, and has it had an impact on db and system performance?

[TheNige]

what are the specs of your sql server now? and how many users/visitors are hitting it to make it maxed out? There are probably lots of tuning things that you could do to sprocs/code, indexes, etc.

[wardbekker]

hi lorenzinho2,

Do you have an good idea the top 5 resource intensive processes of your web-application? If not, first analyse your application and determin which calls to the DB take a lot of CPU to process.

Most of the time caching is paramount!

[Xoc]

Have you maxed out the memory on the box? Memory will make more difference than CPU speed much of the time.

[TheNige]

What are the CPU, Memory Specs of the machine. Your best friend should be Query Analyzer and SQL Profiler that come with SQL server. You can learn which queries are taking a long time with Profiler and with Analyzer what the execution paths are and if they are using the indexes.

Unless you are on a really underpowered box, you should not have too much of a problem with good queries and indices.

Yeah, and caching can help a lot if the same queries are run all the time and return the same results.