SQL Server 2008 Premier Workshop (Porto)

SQL Server 2008 Technical Overview High Availability and Performance Optimization From 12 to 13 November 2009 Session summary: Day 1 SQL Server 2008 High availability and performance troubleshooting •    SQL Server 2008 Log Shipping Setup/Configuration •    SQL Server 2008 Mirror Setup/Configuration •    SQL Server 2008 Cluster Setup/Configuration •    SQL Server 2008 high availability/reliability •    SQL…

0

SQL Server 2005 RTM/SP Setup hangs when displaying patching passive node message

If admin shares are disable on both nodes of the cluster task scheduler might be visible remotely but creating a remote task using task scheduler also hangs. Check the if the following key exists and remove it or change value to 1 and reboot machine: Hive: HKEY_LOCAL_MACHINE Key: SYSTEM\CurrentControlSet\Services\LanManServer\Parameters Name: AutoShareServer Data Type: REG_DWORD Value:…

0

SQL Server 2008 does not start after SP1 with ETW enabled

In case you have just deployed SQL Server 2008 SP1 on a IA64 machine and SQL Server doesn’t start check if you have ETW tracing using MSSQLSERVER provider enabled. SQL Server error log last lines are listed below and no further info is displayed after resource database build info: SQL Server error log: (…) 2009-09-18…

0

SQL Server 2008 Deep Dive Session

Summary: – Higher Availability and scalability (Fail-over clustering, mirroring) – Manageability and Administration (Resource governor, Policy Based Management and Server Group Management) – Virtualization, Storage Savings (virtualization, Data Compression and TDE) – Performance and Auditing(Partitioning, Partition Aligned Indexed Views, Auditing, File Stream) –Troubleshooting and Optimization (Performance Data Collection, X-Events, Data Tuning Wizard) Session slides: SQL…

0

SQL Server 2005 performance problems due grow of TokenAndPermUserStore cache

TokenAndPermUserStore is one of the many caches present in the SQL Server 2005 memory architecture. As the name implies, this cache stores various security related information used by the SQL Server Engine. To find out the amount of memory consumed by this token cache, you can query the DMV’s as follows: SELECT SUM(single_pages_kb + multi_pages_kb)…

0

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

SQL Server 2005 SP2 introduces a new warning message that indicate that working set (RAM resident portion of SQL Server) has been paged out. This is a common problem that points to excessive paging that leads to potential severe performance problems. The following warning message is logged on SQL Server 2005 error log file: (…)…

2

SQL Server Resource IsAlive Troubleshooting

  When SQL Server is deployed on cluster environment there is an associated IsAlive that is responsible to check if SQL Server is online accepting new connections. cluster.log: (…)[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 6; message = [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets](…) On multi SQL Server instance environments with mixed versions of SQL…

0

Exclusive Session – SQL Server Performance Troubleshooting

Session Summary •SQL Server 2000 Performance Troubleshooting •SQL Server 2005 Performance Troubleshooting •SQL Server 2008 Performance Troubleshooting Session slides: Troubleshooting techniques.zip Session labs/demos: Demo 1 – Sql Server 2000 performance troubleshooting (how to guide available at http://blogs.msdn.com/joaol/archive/2008/12/31/sql-server-profiler-trace-parsing-tool-build-performance-reports-based-on-profiler-traces-only.aspx) Demo 2 – Sql Server 2005 performance troubleshooting (how to guide will be published sooner) Demo 3 –…

0

How to build a virtual SQL Server 2008 clustered environment with Hyper-V

1. Install your virtual clients running Windows 2008 Enterprise and make sure they have basic connectivity to each other.  I used the node names and joined them to the contoso domain.   NODEV2  NODEV3 2. Install a free iSCSI SAN software to emulate a iSCSI SAN on host machine or new virtual machine, there are many vendors (http://starwindsoftware.com/, http://sourceforge.net/project/showfiles.php?group_id=90725,…

2

How to install SQL Server 2008 with SP1 built-in (slipstream installation)

This guide will demonstrate how to create new source media that will slipstream the original source media and SQL Server 2008 Service Pack 1. Once you have created this drop, you can install SQL Server 2008 SP1 in a single step! Besides that how SQL Server Setup UI shows that splitstream installation is being used:…

1