Cluster failover SQL : Which Service log do I have to collect when I am victim of an unexpected failover?
Several of my customers uses to ask me : "what kind of information they have collect to make a root cause analysis of the unexpected failover on their SQL Server 2005/2008 failover cluster instance on their Windows 2008? "
You could find below 2 methods:
Cluster failover SQL : Quels sont les logues que je dois collecter lorsque je suis d'un basculement inattendu ?
De nombreux clients me demande régulièrement : "quels types d'informations devons-nous recueillir pour analyser les causes d’un basculement inattendu sur notre instance SQL Server 2005/2008 en cluster failover sur Windows2008 ?"
Vous pouvez suivre une des deux méthodes ci-dessous :
Cluster failover SQL : ¿Cuáles son los logists que recoger cuando estoy en una conmutación por error inesperado ?
Several of my customers used to ask me : "what kind of information they have collect to make a root cause analysis of the unexpected failover on their SQL Server 2005/2008 failover cluster instance on their Windows 2008? " Muchos clientes regularmente me preguntan: "qué tipos de información recogemos para analizar las causas del conmutación por error inesperado en nuestra instancia SQL Server 2005/2008 en Windows 2008 failover clustered ?"
Puede seguir uno de los dos métodos siguientes:
Method 1: This method is the best one to be ensured to get all information that we need for an RCA. Just run the MPS Report tool. it will take a snapshot of all your logs.
http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-88B7-F9C79B7306C0&displaylang=en Use administrator account Please, when you run MPS Report, be ensure that the checkbox below are checked:- General- Internet and Networking- Server component- SQL and other Data Stores (MDAC)
Method 2: You can collect the 5 most important logs by using the command below:
Cluster info:
@ECHO OFFECHO %DATE% > C:\temp\clusterinfo.output.txtECHO %TIME% >> C:\temp\clusterinfo.output.txtCLUSTER /QUORUM >> C:\temp\clusterinfo.output.txtCLUSTER RES >> C:\temp\clusterinfo.output.txtCLUSTER RES /PROP >> C:\temp\clusterinfo.output.txt
Cluster log:CLUSTER /CLUSTER:cluster_name LOG /GENERATE /COPY:”c:\temp”
Event windows:Step 1: Start >> Administration tools >> Event viewerStep 2: On Application et System save as in .CVSStep 3: Also observe the cluster Operational log – Microsoft >> Windows >>FailoverClustering Operational.
How install SQL Server 2008 32Bit on Windows 2008 X64
In a specific case, you have to install SQL Server 2008 32Bit (X86) on Windows 2008 X64. It can be due to the provider of your end application who supports only on a SQL 32Bit his application.
If you want to install SQL server 2008 from the command prompt, you can specify that Setup should install into WOW64 by adding the parameter X86="True". This command line argument is not supported on an IA64 or a 32-bit system.
How to: Install SQL Server 2008 from the Command Prompthttp://msdn.microsoft.com/en-us/library/ms144259.aspx
If you want to run the setup by using the wizard, you can also specify the architecture of SQL Server 2008 to install. You can choose between X86(32bit) and X64 in the tab "Options".
Comment installer SQL Server 2008 32Bit sur un Windows 2008 X64
Dans un cas spécifique, vous devez installer SQL Server 2008 32Bit (X86) sur un environnement Windows 2008 X64. Il se peut que le fournisseur de votre applicaiton final, support seulement sont application sur un SQL Server en 32 bit.
Si vous installer SQL Server 2008 en ligne de commande, vous pouvez spécifier que le Setup doit s'instler sous WOW64 en ajouter le paramétreX86="True". Attention cet argument n'est pas supporter en IA64 ou sur un systéme 32-bit.
Procédure : installer SQL Server 2008 à partir de l'invite de commandeshttp://msdn.microsoft.com/fr-fr/library/ms144259.aspx
Si vous souhaitez exécuter le programme d'installation à l'aide de l'Assistant, vous pouvez également spécifier l'architecture de SQL Server 2008 à installer. Vous pouvez choisir entre X86(32bit) et X64 dans l'onglet "Options".
¿Cómo instalar SQL Server 2008 32 bit en Windows 2008 X 64 ?
En un caso concreto, tienes que instalar SQL Server 2008 32 bits (X 86) en Windows 2008 X 64. Puede ser debido al proveedor de la aplicación final que apoya sólo en un SQL 32 bit su aplicación.
Si desea instalar el servidor de SQL server 2008 desde la línea de comandos, puede especificar que el programa de instalación debe instalar en WOW64 añadiendo el parámetro X86="True". Este argumento de línea de comandos no es compatible con un IA64 o un sistema de 32 bits.
Cómo instalar SQL Server 2008 desde el símbolo del sistemahttp://msdn.microsoft.com/es-es/library/ms144259.aspx
Si desea ejecutar el programa de instalación mediante el asistente, puede especificar también la arquitectura de SQL Server 2008 para instalar. Puede elegir entre X86(32bit) y X 64 en la ficha "Options".
CREATE PROCEDURE getAllTablesSize
AS
BEGIN
DBCC UPDATEUSAGE (0) WITH NO_INFOMSGS;
CREATE TABLE
#temp (
[name] varchar(250),
[rows] varchar(50),
[reserved] varchar(50),
[data] varchar(50),
[index_size] varchar(50),
[unused] varchar(50)
);
INSERT #temp EXEC ('sp_msforeachtable ''sp_spaceused ''''?''''''');
UPDATE
#temp
SET
[rows] = LTRIM(RTRIM(REPLACE(t.rows,'KB',''))),
[reserved] = LTRIM(RTRIM(REPLACE(t.reserved,'KB',''))),
[data] = LTRIM(RTRIM(REPLACE(t.data,'KB',''))),
[index_size] = LTRIM(RTRIM(REPLACE(t.index_size,'KB',''))),
[unused] = LTRIM(RTRIM(REPLACE(t.unused,'KB','')))
FROM #temp AS t
SELECT
SUM(CAST([reserved] as decimal))/1024 AS 'Total reserved MB',
SUM(CAST([data] as decimal))/1024 AS 'Total data MB',
SUM(CAST([index_size] as decimal))/1024 AS 'Total index_size MB',
SUM(CAST([unused] as decimal))/1024 AS 'Total unused MB'
FROM
[name] ,
CAST([rows] as INT)'rows' ,CAST([reserved] as INT)/1024 'reserved MB',
CAST([data] as INT)/1024 'data MB' ,
CAST([index_size]/1024 as INT)'index_size MB',
CAST([unused] as INT)/1024 'unused MB'
ORDER BY
CAST(reserved as INT) DESC
DROP TABLE #temp;
-- rows : Number of rows existing in the table. If the object specified is a Service Broker queue, this column indicates the number of messages in the queue.
-- reserved : Total amount of reserved space for objname.
-- data : Total amount of space used by data in objname.
-- index_size : Total amount of space used by indexes in objname.
-- unused : Total amount of space reserved for objname but not yet used.
-- More detail here : http://msdn.microsoft.com/en-us/library/ms188776.aspx
END
GO
EXECUTE getAllTablesSize