jayraj

TwitterFacebook

jay

Get flash to fully experience Pearltrees
By Jonathan Kehayias, SQL Server MVP. You can view Jonathan’s blog at http://sqlblog.com/blogs/jonathan_kehayias/ . As SQL Server matures with time, the diagnostics tools available to administrators to troubleshoot problems when they arise have also matured. http://msdn.microsoft.com/en-us/library/dd822788(v=sql.100).aspx

Using SQL Server 2008 Extended Events

For those fighting with all the Extended Event terminology, let's step back and have a small overall introduction to Extended Events. This post will give you a simplified end to end view through some of the elements in Extended Events.

Introduction to Extended Events - Using SQL Server Extended Events

http://blogs.msdn.com/b/extended_events/archive/2010/04/14/introduction-to-extended-events.aspx
http://msdn.microsoft.com/en-us/library/ms365393.aspx

The 64-bit versions of Microsoft Windows Server 2003 and Microsoft Windows XP can support more RAM than the 32-bit versions of these products. http://support.microsoft.com/kb/889654

How to determine the appropriate page file size for 64-bit versions of Windows

Understanding SQL server memory grant - Tips, Tricks, and Advice from the SQL Server Query Processing Team

This article describes how query memory grant works in Microsoft SQL Server. http://blogs.msdn.com/b/sqlqueryprocessing/archive/2010/02/16/understanding-sql-server-memory-grant.aspx

SQL Server Central

http://www.sqlservercentral.com/blogs/glennberry/2010/04/23/a-dmv-a-day-_1320_-day-23/ The DMV for Day 23 is sys.dm_os_process_memory , which is described by BOL as:

Page V: SQL Server Architecture

http://www.c-sharpcorner.com/uploadfile/freebookarticles/apress/2008dec16010208am/DataStorageDesign/5.aspx SQL Server Architecture We have already mentioned that SQL Server is quite easy to use, but this can also be one of its drawbacks when it comes to people’s perceptions of this product. As long as you understand what it does and when it behaves in a wrong way, we argue that there is no value in having to tune a database server manually when you can let the built-in logic do it.

How to reduce paging of buffer pool memory in the 64-bit version of SQL Server

http://support.microsoft.com/kb/918483 Microsoft SQL Server performs dynamic memory management based on the memory requirements of the current load and activities on the system. On a Windows Server 2003 or a Windows XP or later version system, SQL Server can use the memory notification mechanisms that are provided by the QueryMemoryResourceNotification Windows API.
http://wtv.watchtechvideos.com/topic11.html

http://www.accelerated-ideas.com/free-mcitp-70-450-test-questions.aspx Background The official Microsoft 70-450 exam is intended for the professional level SQL Server 2008 Database Administrator.

Free MCITP 70-450 Practice Test Questions - Accelerated Ideas

With Performance Data Collector in SQL Server 2008, you can now store performance data from a number of SQL Servers in one central location. This data is collected by a collection set on each server and stored in a shareable management data warehouse (MDW). Reports can be generated from this data using the built-in reports or generating your own with reporting Services.

SQL Server 2008: Performance Data Collector

https://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-performance-data-collector/
Published: June 26, 2006 SQL Server Technical Article

Working with tempdb in SQL Server 2005

Help! My SQL Server Log File is too big!!!

Takeaway: Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth properly, and what can be done to correct the problems.
When you use database mirroring in Microsoft SQL Server 2005, SQL Server automatically propagates any changes on the principal database to the mirror database. However, if you run the DBCC SHRINKDATABASE statement or the DBCC SHRINKFILE statements to shrink the principal database, the shrink operation is not duplicated on the mirror database. Database mirroring will change the physical file sizes only after a checkpoint.

The shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005

The transaction log is used to guarantee the data integrity of the database and for data recovery. The topics in this section provide the information about the physical architecture of the transaction log. Understanding the physical architecture can improve your effectiveness in managing transaction logs.

Transaction Log Physical Architecture

Factors That Can Delay Log Truncation

Log truncation frees space in the log file for reuse by the transaction log.
Pearltrees videos