Browse by Tags

A significant part of sql server process memory has been paged out

Do you have the following occuring on your SQL Server system. If so it is likely you are running SQL Server 2005 or SQL Server 2008 Standard edition on x64 hardware. It will be causing you serious performance issues when it occurs, as all your database pages will be removed from memory and thus SQL will...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Mar 10 2009
Get the tools the professionals use - ReadTrace is now available for SQL 2005

One gripe about SQL 2005 was that read80trace wasn't available for it. That has now been rectified with the release of RML Utilities for SQL Server. This is an application that has a set of utilities for reading, analysing and replaying trace files. This is essential when doing any sort of analysis...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Dec 18 2007
Free 2GB SQL Server USB Keys

We are holding the next UK SQL User group meeting in Central London on the 26th April from 6pm - 9pm (later if you fancy a drink) The eveneing will have a SQL event and BI event running side by side with 8 presenters and loads of giveaways including t-shirts, books and USB keys. If you want to learn...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 29 2007
Update to the taskpad custom report

Thank you to those people that informed me that my taskpad report was incorrectly reporting the backups times against the wrong type of backup. I have now fixed the report and have also included the backup types that are supported by SQL 2005. You can downlaod the new version of the taskpad custom report...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Mar 28 2007
SQL Server Trace Event Definitions

If you are using Event Notifications or capturing events in Profiler you undoubtedly have noticed that MS have used the same columns (xml elements) for storing different data for each event. For example there is an element called "integer data". You may ask what is stored in here cos it ain't...

Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Mar 23 2007
Maintenance plan warning for SP2

Due to a regression bug introduced in SP2 some of the maintenance plan tasks that can operate on multiple databases may not perform as expected. If a maintenance plan component uses TSQL of this nature USE [DBFred] GO DBCC CHECKDB.... GO USE [DBSimon] GO DBCC CHECKDB.... To handle errors in the process...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 8 2007
Taskpad view version2

This is a pure plagurism of Jaspers taskpad report . I have reformated the report to look like the taskpad in EM as close as possible. You can download the taskpad view custom report here - var height=90;var width=720;

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Nov 23 2006
Custom reports in SQL 2005 SP2

You may have come across the fact that in SP2 you can deploy custom reports that are accessible in management studio. This reports can be run from any context in the object explorer tree. Whilst I think this is really interesting, I haven't played with it much, but Anthony has read his blog post...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Nov 16 2006

Page 1 of 1 (8 items)