spiritofadhie.wordpress.com
Error: 18056, Severity: 20, State: 29 « semangat….
https://spiritofadhie.wordpress.com/2014/01/09/error-18056-severity-20-state-29
Buat semua yang kau cintai…………. Aku….Saya…. Error: 18056, Severity: 20, State: 29. Kemarin saya mendapati error log pada mesin SQL server saya. Error: 18056, Severity: 20, State: 29. The client was unable to reuse a session with SPID 56, which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message. High CPU usage occurs. Error: 9954, Severity: 16, State: 1.
adminontherun.blogspot.com
Admin On the Run: September 2012
http://adminontherun.blogspot.com/2012_09_01_archive.html
Admin On the Run. Tips, tricks, and scripts for Admins on the run. Also this serves a a brainless repository for me when I know I'll need it later. Monday, September 24, 2012. Case of the decommissioned DHCP Server. So a client decommissioned several DHCP servers improperly. So every time you opened the DHCP Console, it displayed those servers even though they have been gone for some time now. Connect to the configuration container. Navigate to CN=configuration,CN=Services,cn=Netservices.
patrickkeisler.com
Everyday SQL: July 2015
http://www.patrickkeisler.com/2015_07_01_archive.html
Tuesday, July 21, 2015. PSSDiag Configuration Manager – A Companion for SQLNexus. Have you ever called Microsoft Customer Support for help with a SQL Server performance issue? The answer is PSSDiag Configuration Manager, or simply DiagManager. DiagManager is just a tool that you use to configure which performance items are to be collected by the SQLDIAG utility. The configuration files that come with SQLNexus (see my previous post. The first thing you’ll likely notice is a line of tabs across the t...
patrickkeisler.com
Everyday SQL: PSSDiag Configuration Manager – A Companion for SQLNexus
http://www.patrickkeisler.com/2015/07/pssdiag-configuration-manager-companion.html
Tuesday, July 21, 2015. PSSDiag Configuration Manager – A Companion for SQLNexus. Have you ever called Microsoft Customer Support for help with a SQL Server performance issue? The answer is PSSDiag Configuration Manager, or simply DiagManager. DiagManager is just a tool that you use to configure which performance items are to be collected by the SQLDIAG utility. The configuration files that come with SQLNexus (see my previous post. The first thing you’ll likely notice is a line of tabs across the t...
spiritofadhie.wordpress.com
2014 January 09 « semangat….
https://spiritofadhie.wordpress.com/2014/01/09
Buat semua yang kau cintai…………. Aku….Saya…. Copy ODBC dari PC satu ke PC lainnya. Seringkali menjadi pertanyaan ketika menghadapi unit PC atau Profile User yang memiliki banyak settingan ODBC , bagaimana memindahkan settingan ini :. Pindahkan dulu setting mapping network drive dari sini regedit : Hkey current user network. Pindahkan setting odbc dari hkey local machine software odbc. January 9, 2014. Error: 18056, Severity: 20, State: 29. Kemarin saya mendapati error log pada mesin SQL server saya. FIX: ...
codeplex.com
CodePlex - DanMaxic
http://www.codeplex.com/site/users/view/DanMaxic
Project Hosting for Open Source Software. Member Since April 25, 2012. Last Visit January 21, 2016. SQL Server Quick Tools Pack. SQL Server Snapshot manager. No personal statement has been written. No activity in the last 60 days. Internals Viewer (updated) for SQL Server 2008 R2. Internals Viewer for SQL Server. Microsoft SQL Server Community & Samples. Performance Analysis of Logs (PAL) Tool. Pssdiag and Sqldiag Manager. SQL Server BareMetal Hands-on-Labs. SQL Server Partition Management.
codeplex.com
CodePlex - jackli
http://www.codeplex.com/site/users/view/jackli
Project Hosting for Open Source Software. Member Since October 22, 2007. Last Visit December 30, 2015. Pssdiag and Sqldiag Manager. As a Senior Escalation Engineer at Microsoft, I help customers with wide range of SQL Server issues including Server and Query performance problems. I also develop and maintain SQL Server performance troubleshooting tools Pssdiag. No activity in the last 60 days. No projects being followed. Version 8.21.2015.21031.
johnsterrett.com
SQL Server Performance Tuning for Pirates! | JohnSterrett.com SQL Server Consulting
http://johnsterrett.com/presentations/sql-server-performance-tuning-for-pirates
JohnSterrett.com SQL Server Consulting. I am an independent consultant based in Austin, TX who focuses on providing SQL Server solutions. Building Your First Data Warehouse with SQL Server. SQL Server Performance Root Cause Analysis. 12 Steps to Workload Tuning. Automate SQL Server Builds. Building Your First AlwaysOn Failover Cluster Instance. Evaluate your daily checklist against 100 instances with PBM and CMS. Intro to Policy-Based Management and Central Management Server. PSSDiag and SQLDiag Manager.
sqlmagu.blogspot.com
SQL MAGÚ: Março 2014
http://sqlmagu.blogspot.com/2014_03_01_archive.html
SELECT * FROM HELP US =). SQLdiag - Parte 3 - Configurando o SQLdiag (Script's customizados). Fala galera tudo tranquilo? Estou saindo de férias e ficarei alguns dias sem postar coisas novas por aqui, mas, para sair em "grande estilo" estou publicando mais um post da série sobre o SQLdiag! Hoje vou demonstrar como fazer com que o utilitário colete também resultados de scripts disparados de tempos em tempos contra a instância do SQL Server que deseja monitorar. Http:/ diagmanager.codeplex.com/. Agora copi...