Last month I’ve wrote an article on Performance Data Collector part one, I thought of writing part 2 soon however I was stuck with Organizing SQL Code Camp with my fellow MVP Deepak & Sugesh. Now it’s almost a month so thought of writing the second part. In this part we are going to see how to customize the data collection, retrieval of reports from PDW (Performance Data Warehouse) etc.
Author Archives: Vidhya Sagar - Page 4
SQL Code Camp at Chennai–Great Success
Posted by Vidhya Sagar
on July 21, 2010
3 comments
I, Deepak & Sugesh have organized SQL Code Camp – One full day event for SQL Server last Saturday (17th July 2010). We are happy to say that this is the first one full day event for SQL Server held in India and we are proud that we are organizing it. Deepak and Sugesh has already created a post so I’m not going to write much about the event. You can find our experiences and learning from the link below.
Performance Data Collector – Part 1
Posted by Vidhya Sagar
on June 24, 2010
No comments
Performance Data Collector is one of the new features that’s accompanied from SQL Server 2008. If you are a DBA , you know it’s very hard to get performance data from necessary inputs. We will get the data from Perfmon (system monitor), profiler, DMV etc and correlating this data is very hard, implementing the same process or scripts across your environment is also time consuming one. To Overcome this MS has added Performance data collector feature in SQL 2008. In a Nutshell performance data collector will collect performance data (integrating all your data from your server), upload it in centralized management data warehouse (MDW) in relational format and finally allows you to see reports in graphical format.
SQL Data Camp @ Chennai – 17th July 2010
Posted by Vidhya Sagar
on June 14, 2010
No comments
We are excited to open our mouth wide to shout "Yes, We are ready. Are you?"
SQL Data Camp @ Chennai is all set for making a claim to be First ever largest SQL Server Event to be held in India.
Installing SQL Server 2008 R2
Posted by Vidhya Sagar
on May 24, 2010
3 comments
In this article we are going to discuss about installing SQL Server 2008 R2, I know I’m little late as R2 is released last month. Before we stepping into installation make sure you have necessary hardware and software requirements, check http://technet.microsoft.com/en-us/library/ms143506(SQL.105).aspx this KB article for the same.