Browse by Tags

SQL Server 2008 Analysis Services performance guide - process to go over

Published 27 November 8 11:34 AM | SqlServer-QA.net

SQL Server 2008 is on full-fledge now and I haven't had a chance to look at Analysis Services part of it, recently had an opportunity to go through to convene a proof of concept project at work place. As the documentation refers this version of Analysis...

Filed under: sql server, performance, mdx, monitoring, resources, Analysis Services

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

SQL Server 2005 Scalability and Performance - recommended limit on number of instances on a clustered environment?

Published 4 April 8 4:48 AM | SSQA.net

This is a very tricky question and hard to stick to 1 or few solutions as answer, it depends! Overall the say is if there isn’t any resource contention (from your pre-installation testing & analysis) and there is enough of each resource to go around...

Filed under: sql server, memory, maintenance plan, i/o, clustered, best practice, monitoring, resources, configuration, performance monitoring, contention

Various blog links for sharepoint and office products

Published 19 March 8 7:32 AM | SSQA.net

Though I'm an expert within SQL Server arena, sometimes I find it bit difficult when the sharepoint database are involved with an added flavour of performance issues within this farm. So in this regard recently I have been searching through the web...

Filed under: sql server, microsoft, blogs, sharepoint, resources, links

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

New drive in problem resolution by Microsoft Product Support Services - SQL Server

Published 7 September 7 5:32 AM | SSQA.net

Microsoft Product/Customer Support Services has introduced new phase of provision to address the user issues. This program has been divided into various phases such as assessment, configuration and management with a flavour of Performance & Tuning...

Filed under: sql server, microsoft, security, services, customer, support, resources, problem, product, resolution

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

Resources for beginners in MS SQL Server and new DBA

Published 20 August 7 3:36 AM | SSQA.net

" Give me some good resource that I can refer as new dba or beginner or new learner " this is the question asked by beginners and new learners in various forums I participate, thus I decide to post a blog referring the same, they are: Here are...

Filed under: sql server, best practices, resources, beginners, samples, new dba