|
||||||
|
We had an incident today where a set of SQL performance counters were not showing in Perfmon. The performance counters in question were the SSISPipeline set on a 64bit instance of SQL Server 2005, the reason why they were not showing was that in a 64 bit installation the registry setting that stores the location of [...] The following KB articles/patches for SQL Server have been released over the last few days: SQL Sever 2005 You have to reinstall some drivers when you install SQL Server 2005 In a previous post “Moving TempDB” I provided step by step instructions on how you can move your TempDB database with an emphasis on reducing disk IO contention. If you have read this post you will notice that I did not change the path for the TempDB database files from the USB stick back to their [...] One of the planned projects in my schedule for the coming financial year is to add some new disks in to one of our SQL servers. As part of this project I will be moving the TempDB database onto a different disk thereby helping to reduce the IO contention on the server. [...] On Sunday night I was implementing a significant change release on our main production environment and thought after after implementing numerous implementation and migration projects over the years that a blog on the mechanics of change control could be a great help to people in their jobs, be it Developer, DBA or Project Manager. I hope there’s something in here for everyone. [...] Microsoft have released version 5.0 of MAP (Microsoft Assessment and Planning (MAP) Toolkit) [...] Whist reviewing various logs on SQL Servers across the estate I was greeted with the following error on one of our SQLExpress instances this morning: The application domain WindowsService_22 failed to initialize. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the [...] |
||||||
|
Copyright © 2012 Richard Douglas – SQL Server Professional - All Rights Reserved |
||||||
