Using Memory Beyond 4GB in SQL Server
|
Physical Address Extension (PAE) allows you to use up to 64 GB of physical memory depending on operating system you use. All existing 32 bit processors supports this extension of memory. PAE mode requires an Intel Architecture processor and more than 4GB of RAM. |
 |
You can configure at two levels to use Memory Beyond 4GB in a 32 bit windows server operating system.
- Operating System Level
- Application Level
To enable operating system to access more than 4GB of physical memory , add a /PAE switch in boot.ini file as below
Related Posts:
No commentsAnalyzing SQL Server Performance using Performance Monitor Counters
|
This post discusses about using Performance Monitor tool to create a base-line using different performance counters. It also discusses analyzing hardware resource bottlenecks and retrieving performance monitor data in sql server using views. Performance Monitor Tool collects the detailed information of system resources including memory, processor , disk and network.SQL Server 2008 provides extensions to Performance Tool to analyze various areas in SQL Server. |
 |
Performance Monitor tool provides performance counters to represent the specific aspects of a resource.
What is Performance Counter?
Related Posts:
No commentsWhat is new in SQL Server Code-Named “Denali”?
|
This post just re-caps the T-SQL features that introduced in SQL Server 2008 and discusses the new T-SQL features in Microsoft SQL Server next version code name “Denali”. Actually there are not any T-SQL features in SQL Server 2008 R2 as it is purely a BI release. You can download the Denali CTP version from here |
 |
Related Posts:
2 commentsCreating SQL Server Database Objects Backup using SMO
|
This post explains taking the SQL Server Database Objects backup only schema not data in SQL Server 2008 R2. In an ETL server you may come across the situation where you need to change the database objects schema quite frequently especially when data source changes. In this case we may need maintain our schema or take the backup our database objects script some place where we can restore them back to the server. |
|
What is SMO?
This can be achieved in earlier versions of SQL Server using Distributed Management Objects (DMO) but now it is no longer supported in SQL Server 2008 R2 and future versions. We can achieve the same using SQL Server Management Objects (SMO) in 2008 R2. SMO provides objects which are used to manage SQL Server.
Related Posts:
1 commentCreating Maintenance Plans in SQL Server 2008 R2
| One of the repetitive task that DBA need to perform is create maintenance plan for database. Maintenance plans enables you to automate maintenance activities for a database, backups, db integrity checks and index maintenance tasks. We can easily create a maintenance plan using a wizard in sql server 2008 R2. | |
You can use the following steps to create a maintenance plan
1. Select the Maintenance Plan Wizard from the context menu as shown below
Related Posts:
No commentsCreating Maintenance Plans in SQL Server 2008 R2
| One of the repetitive task that DBA need to perform is create maintenance plan for database. Maintenance plans enables you to automate maintenance activities for a database, backups, db integrity checks and index maintenance tasks. We can easily create a maintenance plan using a wizard in sql server 2008 R2. | |
You can use the following steps to create a maintenance plan
1. Select the Maintenance Plan Wizard from the context menu as shown below
Related Posts:
3 commentsMonitoring running processes in SQL Server 2008 R2
|
You can view the current connections and processes that running on a sql server instance in two ways
|
|
Monitoring Process in Activity Monitor
To open the Activity Monitor in SQL Server Management Studio Right click the server then select the Activity Monitor option as shown below
Related Posts:
No commentsSQL Server Reporting with Analysis Services
| SQL Server Analysis Services is used to present the aggregated data to support analysis, ad-hoc reporting and decision making process. Technically CUBE is used in Analysis Services to build the aggregated data. Once it is build then you can easily navigate and produce reports for business analysis. This post discusses using analysis services in SQL Server Reporting with MDX query builder. | |
To download and configure the AW analysis services database read my previous post.
Create a Data Source
1. Create a data source for the AW20082 Analysis Services database in Report Builder 3.0 and select the SQL Server Analysis Services data provider from the drop down list.
Related Posts:
1 commentFiltering Techniques for SQL Server 2008 R2 Reports
|
It is important to consider to filter report data based on user’s selection criteria as many databases contain large amounts of data. This post discusses different techniques to filter report data using report parameter concepts. By using the filters on reports, it greatly reduces the network traffic and helps the report to render efficiently. |
|
We are using same data source and query that we used to demonstrate the tabular reports demo. You can read the post here.
Filtering by query - You can filter the records in query by adding a where clause to it. Write the following query in query designer as follows
Related Posts:
No commentsTabular Reports in SQL Server 2008 R2 Reporting Services
| It is important to understand the reporting options available in SQL Server 2008 R2 to provide an appropriate report layout to meet the business requirements and needs of our end users. This post briefly discusses about different report layout types available and explains in detail the steps to create a Tabular Report. It also explains how to sorting and drilldown features to your report. | |
Different Available Report Layouts are
- Tabular Reports – these reports are defined using table data and organized in to rows and columns. The columns are typically fields in the table. Reporting detail rows can be grouped on various fields, each group can have header, footer , breaks and subtotals.
