jayraj
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.
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 - Site Home - MSDN Blogs
March 29, 2010 by pinaldave
SQL SERVER – Introduction to Extended Events – Finding Long Running Queries « Journey to SQLAuthority
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.
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 - Site Home - MSDN Blogs
This article describes how query memory grant works in Microsoft SQL Server.
Sudarshan Narasimhan « TroubleshootingSQL
Well, this is often a tricky situation, where you are running into Virtual Address Fragmentation and getting OOM (out-of-memory) errors in your SQL Server.Page V: SQL Server Architecture
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.
How to reduce paging of buffer pool memory in the 64-bit version of SQL Server
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
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.
SQL Server 2008: Performance Data Collector
Summary: This white paper describes how SQL Server 2005 uses tempdb . Many improvements in SQL Server 2005 optimize tempdb usage and make it easier to manage and to troubleshoot.
Working with tempdb in SQL Server 2005
Help! My SQL Server Log File is too big!!! | TechRepublic
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. To work around this problem, run the following statements to create a new stored procedure in the master database.
The shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005
[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]
Transaction Log Physical Architecture
Pearltrees videos