Performance Data Collector – Part 2
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.
Performance Data Collector – Part 1
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.
Installing SQL Server 2008 R2
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.
Creating Linked server to SYBASE from SQL Server
In this article we going to look into creating a heterogeneous linked server. i.e. We are going to create a linked server to SYBASE database server from SQL Server environment and then going to query data’s from Sybase. First step in heterogeneous linked server is to create a ODBC connection to that RDBMS platform. For creating ODBC connection we need the ODBC drivers for that RDBMS platform. In this case we need Sybase driver in client machine, this is not included in windows so you need to download it from Sybase Website. Lets discuss on this step by step
IP Address Blocking or Restriction in SQL Server
I have seen some questions in forums asking for the answer “is it possible to block connections to SQL Server based on IP address”. As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.