Browse by Tags

SQL Server Reporting Services: Resources and information - all in one place

Published 13 May 8 3:30 AM | SSQA.net

During a conference few users asked about resources and information to go through the Reporting Services, as it is a general assumption from the end-user community that referring to Books Online aka BOL doesn't get them anywhere. I always recommend...

Filed under: sql server, performance, reporting services, resources, information, books online, business intelligence, troubleshooting

If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?

Published 15 November 7 9:41 AM | SSQA.net

Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must...

Filed under: sql server, performance, microsoft, server, tuning, dbcc, system, best practice, testing, resources, sqlperf, max worker threads

High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!

Published 20 September 7 10:40 AM | SSQA.net

Here comes another Frequently Asked Question (FAQ) on the forums and Frequently Posted Blog (FPB) here about high cpu issues on the SQL Server 2000 instances. Looking at high cpu spiks and performace issues is a common problem in all SQL Server installations...

Filed under: sql server, performance, databases, blogs, blocking, query, kba, cpu, execution plan, backups, resources, high cpu, FAQ

Whats the best way to setup memory on a four-node cluster?

Published 6 September 7 4:42 AM | SSQA.net

Though it is more to do with SQL Storage kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances...

Filed under: sql server, performance, analysis, high availability, ssis, security, ssas, ssms, clustering, resources