SS2k5 EE: SAN, Allocation Units, And All That Jazz
Feb 2, 2007
I've been doing some testing on the SAN/Disk subsystem over the past few days. I've run into something that is bugging me though. Hopefully someone here has run into the same thing or can answer.
*All LUNs have been created with default selects.
Test 1:
LUN1 (H:) - Created partition with diskmanager in win2003.
LUN2 (I:) - Created partition with diskpart and aligned the sectors at 64k.
Formatted both disks to have 4k in the allocation units.
Created a new blank DB on each disk.
With Profiler running, I ran a bulk insert for both disks and also ran a "Select count(*), Sum(total) from tableA" for both databases and cleared the proc cache inbetween.
Profiler showed the reads and writes io for the import and selects as a the same number (468721 reads and 312182 writes).
Test 2:
Deleted partitions
LUN1 (H:) - Created partition with diskmanager in win2003.
LUN2 (I:) - Created partition with diskpart and aligned the sectors at 64k.
Formatted both disks to have 8k in the allocation units.
Created a new blank DB on each disk.
With Profiler running, I ran a bulk insert for both disks and also ran a "Select count(*), Sum(total) from tableA" for both databases and cleared the proc cache inbetween.
Profiler showed the reads and writes io for the import and selects as a the same number (468721 reads and 312182 writes).
Test 3:
Same as test 2 but formatted with 64k allocation units.
So here is my question: Shouldn't the I/O go down or at least change if you change the allocation unit size for the disk?
Error: 2008-03-05 18:44:11.20 Code: 0xC004704A Source: Load Source Data into Staging Database DTS.Pipeline Description: The buffer manager cannot extend the file "C:TEMPDTSDD1.tmp" to length 917284. There was insufficient disk space. End Error
Does anyone know what unit (bytes, KB, MB) is used for the length value in this error? I've searched around online but have not found any information.
i think this feature is so crappy compare to the one from 2000. Because once you create the linked server you are not able to see the tables as you can do it on 2000.
how do you expect someone to query the tables if its not there.
I am in need of some answers on SS2K5 Encryption and possible issues when used in a clustered(replicated) configuration as well as having the encryption work on a Test/UAT configuration.
Here is the scenerio:
ServerA - is the Primary/Active server in a NeverFail cluster. NeverFail is a replication method like MS Clustering is except NF replicates the server to EXACT mirrors of each other.
ServerA has lets say 2 client DBs (actually we have 10-20 but for simplicity we will say 2.)
ServerB is the Secondary/Passive node.
First question is ... what issues may I run into if I encrypt the 2 clients needed data in the DBs and we then have a failover. I figure we should not see an issue if NeverFail is replicating everything including the machines SIDs.
Now for the second question:
We also have a Test/UAT server that we restore backups from the production clusters. On this server we have upwards of 60+ DBs from 8 different NeverFail clusters.
What are the issues that I may encounter in this scenerio?
I thought that each server generates its own master key per instance of SQL Server.
SO how will I bring that master key over to the Test/UAT server and use it knowing I will also need to have the other 7 master keys from the other 7 clusters?
I am sure this initial post will generate more conversation and probably will need more details on my behalf but I wanted to start out simple and dive into this issue.
Each client has 5 Full-Text Catalogs. For ease of explanation let€™s call the FTCs C1 thru C5.
Now each client€™s FTCs are named the SAME. So each client has FTCs named C1, C2, C3, C4 and C5.
I need to move the clients to our new SQL Server 2005 Enterprise server.
I can backup up the DB using the native SQL Server 2000 backup command but that of course does not back up the FTCs.
So once I restore the client DB over to the new SS2K5 server, how do I re-enable the FTCs and rebuild them so that they are the same as what was over on the SS2K server.
Also, after the first client is complete, will I run into a duplicate FTC error when I try to recreate the subsequent clients on the server since they all have the same named FTCs?
Our software applications require the sa login to be enabled. We have a .NET (C#) installation application that installs our software applications.
So, is there any way that we can programmatically enable the sa login for SQL Server 2005? Ideally, we'd like to code this into our installation application.
I have a couple of tables set up with column level tracking and using the "Subscriber Always Wins" conflict resolver.
I am still trying to work out why there is a conflict as the only updates to these rows happen at the subscriber.
What I am finding is that a conflict occurs and there appears to be a delay between the conflict being recognised and then resolved.
The reason I know there is a delay is because this is playing havoc with a data extract that relies on the updates from the subscriber.
For instance, I have a job on which the status is changed. That status change triggers an extract via BizTalk to another system. BizTalk, via an SQL adapter extracts the data from the server and I find that some of it is missing in the extract.
I go and look into the database at the raw data and find that the data is in fact there.
I have certain triggers running which set up export flags in the database to say this data should be exported. This works perfectly when there are no conflicts.
In each case where data has not been extracted, a conflict occurs.
Is there any way to guarantee that the conflict will be resolved at the same time as the synchronisation is complete - i.e. within the same transaction?
I thought replication was supposed to be a single transaction - you get it all or you get nothing.
I'm interested to hear from anyone who has experienced this behaviour.
Hi Settled into the new giggero now. Since I have moved here we have upgraded our 4 SQL Servers to 2005 64 bit. All 2 proc dual core hyper threaded with 4GB RAM. Windows 2003. SQL Server compatibility level is 90. SP 1 and the CTP for SP2 are installed. We are hanging on with sp2. Maxdop is 0 (but has been tried on 2). Up to a score or so databases per machine, between 8 and 300 GB in size. Offline, reasonably heavy duty ETL batch processing. Since upgrading we have had trouble with the CPUs intermittently maxing out at 100% usage. This is when intensive routines are run. We know that many of these routines are crappy (SELECT... INTO creating tables with 10s or 100s of millions of rows, cursors etc.) and we are rewriting the code. Estimated time of completion of code review and rewrite is end of next year so we can't wait that long. The same poor code ran (albeit slowly) in SS2k but is causing the server to lock up now it is being run on SS2k5. Symptoms include connection attempts timing out, routines running very slowly. Existing connections can continue to make requests but these are very slow. If we get on the box the CPUs are at a never wavering 100% utilisation. This continues until intervention is taken, often restarting the service. We have left a maxed out box alone over a weekend and it was still in the same state when we came in on Monday. Nothing to glean from the error logs (AFAIK). Obviously the long term fix is to get the code sorted but this is an ongoing process (in fact it is one of the reasons I was hired). Our immediate concern is to get the servers back up to the sort of performance we were realising before we upgraded. Does anyone have any ideas?As ever eternal gratitude and a crate of virtual beer for any help :D
Has anyone run into the issue of installing SP1 on a 2003 R2 server?
I have seen a post or two on other sites but I cannot seem to find them again.
Install goes great up until it comes to the upgrading of SSIS (Integration Services).
At that point is fails with the error of:
A recently applied update, KB913090, failed to install.
This is a dialog box that I hit the "send error report" button. It then goes to the upgrading of the Client Components (CC) and fails with the same error message of:
A recently applied update, KB913090, failed to install.
The ugrade the continues after I hit the same "send error report"button.
ALL of the other steps complete with SUCESSFULLY. Only the SSIS and Client Components show a failed status in the Installation Prog
In the Installation Complete screen, I can highlight both the SSIS and CC and see an additional error of:
Unable to install Windows Installer MSP file
I then can hit the View Log button (which I have done for the SSIS step) and see the error log but I am having a tough time making heads or tails of it.
I have attached the output from the SSIS error log below.
I have a couple of questions:
1. Is the install of SP1 good for all the other steps that completed successfully
2. Has anyone had issues with installing SP1 on a Windows 2003 R2 server? I have installed SP1 on other Windows 2003 servers NOT running R2 and it ran like a champ.
Thanks ALL!
====== ERROR LOG FROM SSIS UPGRADE ============================================
01/07/2007 19:23:23.247 ================================================================================ 01/07/2007 19:23:23.247 Hotfix package launched 01/07/2007 19:23:23.747 Product discovery successfully completed during the install process for DTS 01/07/2007 19:23:23.762 SP Level check successfully completed during the install process for DTS 01/07/2007 19:23:23.778 Product language check successfully completed during the install process for DTS 01/07/2007 19:23:23.793 Product version check successfully completed during the install process for DTS 01/07/2007 19:23:23.825 Command-line instance name check completed during the install process 01/07/2007 19:23:23.840 Baseline build check completed during the install process 01/07/2007 19:28:41.393 Attempting to install instance: DTS 01/07/2007 19:28:41.408 Attempting to install target: AUS02DB13 01/07/2007 19:28:41.440 Attempting to check for locked files: sqlrun_dts.msp 01/07/2007 19:28:41.502 Attempting to check for locked files: \AUS02DB13g$2fe15a257eaedfc36c121fc912HotFixDTSFilessqlrun_dts.msp 01/07/2007 19:28:41.518 Creating MSP locked file check log at: C:WINDOWSHotfixDTS9LogsDTS9_Hotfix_KB913090_sqlrun_dts.msp.out 01/07/2007 19:28:48.799 MSP returned 1602: The user cancels installation. 01/07/2007 19:28:49.017 Successfully checked file: \AUS02DB13g$2fe15a257eaedfc36c121fc912HotFixDTSFilessqlrun_dts.msp 01/07/2007 19:28:49.033 Successfully opened registry key: SystemCurrentControlSetControlSession Manager 01/07/2007 19:28:49.064 Successfully read registry key: PendingFileRenameOperations 01/07/2007 19:28:49.080 Multi-string values: 01/07/2007 19:28:49.096 ??g:a4be8c9b1bce3ffa869bbb5137 01/07/2007 19:28:49.111 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerShared9.0.2047.0 C:Program FilesMicrosoft SQL ServerShareddbghelp.dll 01/07/2007 19:28:49.127 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedSqlDumper.exe 01/07/2007 19:28:49.142 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedSqlDumper.exe 01/07/2007 19:28:49.158 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedSqlDumper.exe 01/07/2007 19:28:49.174 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsqm.exe 01/07/2007 19:28:49.205 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinndtsinstall.exe 01/07/2007 19:28:49.221 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesmsmdsrv.rll 01/07/2007 19:28:49.236 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesmsmdsrv.rll 01/07/2007 19:28:49.252 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesmsmdsrv.rll 01/07/2007 19:28:49.267 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsmsmdlocal.dll 01/07/2007 19:28:49.283 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsmsmdlocal.dll 01/07/2007 19:28:49.299 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsmsmdlocal.dll 01/07/2007 19:28:49.314 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponents9.0.2047.0 C:Program FilesMicrosoft SQL ServerSharedmsmdlo~1.dll 01/07/2007 19:28:49.330 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServerCe.Dts.Provider9.0.242.0__89845dcd8080cc91Microsoft.SqlServerCe.Dts.Provider.dll 01/07/2007 19:28:49.361 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataStorage9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataStorage.dll 01/07/2007 19:28:49.377 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.CustomControls9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.CustomControls.dll 01/07/2007 19:28:49.392 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WizardFramework9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WizardFramework.dll 01/07/2007 19:28:49.408 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.Xmla9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.XMLA.dll 01/07/2007 19:28:49.424 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.OlapEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.OlapEnum.dll 01/07/2007 19:28:49.439 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.ActiveXScriptTask.xml 01/07/2007 19:28:49.455 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.ActiveXScriptTaskUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTaskUtil.dll 01/07/2007 19:28:49.470 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.ActiveXScriptTaskUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTaskUtil.dll 01/07/2007 19:28:49.486 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.ActiveXScriptTaskUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTaskUtil.dll 01/07/2007 19:28:49.517 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ActiveXScriptTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTask.dll 01/07/2007 19:28:49.533 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.ActiveXScriptTaskUtil.dll 01/07/2007 19:28:49.549 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.ActiveXScriptTask.dll 01/07/2007 19:28:49.580 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataTransformationServices.Controls9.0.242.0__89845dcd8080cc91Microsoft.DataTransformationServices.Controls.DLL 01/07/2007 19:28:49.595 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTSWizard.exe 01/07/2007 19:28:49.611 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5SDKAssembliesMicrosoft.SqlServer.TxScript.dll 01/07/2007 19:28:49.627 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsMicrosoft.SqlServer.TxScript.dll 01/07/2007 19:28:49.642 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TxScript9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TxScript.dll 01/07/2007 19:28:49.674 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSampling.dll 01/07/2007 19:28:49.689 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSampling.dll 01/07/2007 19:28:49.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSampling.dll 01/07/2007 19:28:49.720 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxRowCount.dll 01/07/2007 19:28:49.752 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxRowCount.dll 01/07/2007 19:28:49.767 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxRowCount.dll 01/07/2007 19:28:49.783 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Dts.DtsClient9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Dts.DtsClient.dll 01/07/2007 19:28:49.799 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataReaderDest9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataReaderDest.dll 01/07/2007 19:28:49.814 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.Dts.DtsClient.dll 01/07/2007 19:28:49.830 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsMicrosoft.SqlServer.DataReaderDest.dll 01/07/2007 19:28:49.830 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferSqlServerObjectsTask.xml 01/07/2007 19:28:49.845 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferSqlServerObjectsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferSqlServerObjectsTask.dll 01/07/2007 19:28:49.877 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferSqlServerObjectsTask.dll 01/07/2007 19:28:49.892 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferStoredProceduresTask.xml 01/07/2007 19:28:49.908 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferLoginsTask.xml 01/07/2007 19:28:49.924 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferJobsTask.xml 01/07/2007 19:28:49.939 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferErrorMessagesTask.xml 01/07/2007 19:28:49.970 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferDatabasesTask.xml 01/07/2007 19:28:49.986 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferStoredProceduresTask.dll 01/07/2007 19:28:50.002 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferLoginsTask.dll 01/07/2007 19:28:50.002 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferJobsTask.dll 01/07/2007 19:28:50.033 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferErrorMessagesTask.dll 01/07/2007 19:28:50.033 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferDatabasesTask.dll 01/07/2007 19:28:50.049 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferObjectsTask.dll 01/07/2007 19:28:50.064 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferStoredProceduresTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferStoredProceduresTask.dll 01/07/2007 19:28:50.080 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferLoginsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferLoginsTask.dll 01/07/2007 19:28:50.095 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferJobsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferJobsTask.dll 01/07/2007 19:28:50.111 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferErrorMessagesTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferErrorMessagesTask.dll 01/07/2007 19:28:50.111 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferDatabasesTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferDatabasesTask.dll 01/07/2007 19:28:50.127 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferObjectsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferObjectsTask.dll 01/07/2007 19:28:50.142 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DtsTransferProvider9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DtsTransferProvider.dll 01/07/2007 19:28:50.158 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TableTransferGeneratorTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TableTransferGeneratorTask.dll 01/07/2007 19:28:50.174 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.DtsTransferProvider.dll 01/07/2007 19:28:50.189 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TableTransferGeneratorTask.dll 01/07/2007 19:28:50.189 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermExtraction.dll 01/07/2007 19:28:50.205 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermExtraction.dll 01/07/2007 19:28:50.220 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermExtraction.dll 01/07/2007 19:28:50.236 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermLookup.dll 01/07/2007 19:28:50.252 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermLookup.dll 01/07/2007 19:28:50.267 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermLookup.dll 01/07/2007 19:28:50.283 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResources.90.2047.0 E:MSSQLMSSQLSS2K5DTSBinnResourcesdts.rll 01/07/2007 19:28:50.283 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtsconn.rll 01/07/2007 19:28:50.299 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtsconn.rll 01/07/2007 19:28:50.314 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtsconn.rll 01/07/2007 19:28:50.330 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsenMicrosoft.SqlServer.ForEachAdoEnumerator.xml 01/07/2007 19:28:50.345 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsenMicrosoft.SqlServer.ForEachSMOEnumerator.xml 01/07/2007 19:28:50.377 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSConnectionsenMicrosoft.SqlServer.ManagedConnections.xml 01/07/2007 19:28:50.392 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTSPipelinePerf.dll 01/07/2007 19:28:50.408 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtspipeline.rll 01/07/2007 19:28:50.408 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtspipeline.rll 01/07/2007 19:28:50.424 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtspipeline.rll 01/07/2007 19:28:50.439 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.FtpTask.xml 01/07/2007 19:28:50.455 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.FtpTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.FtpTask.dll 01/07/2007 19:28:50.470 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.FtpTask.dll 01/07/2007 19:28:50.486 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.ExecProcTask.xml 01/07/2007 19:28:50.517 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.SendMailTask.xml 01/07/2007 19:28:50.549 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.MSMQTask.xml 01/07/2007 19:28:50.580 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.MSMQUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQUtil.dll 01/07/2007 19:28:50.595 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.MSMQUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQUtil.dll 01/07/2007 19:28:50.595 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.MSMQUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQUtil.dll 01/07/2007 19:28:50.611 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.MSMQTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQTask.dll 01/07/2007 19:28:50.627 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.MSMQUtil.dll 01/07/2007 19:28:50.642 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.MSMQUtil.dll 01/07/2007 19:28:50.658 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.MSMQUtil.dll 01/07/2007 19:28:50.674 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.MSMQTask.dll 01/07/2007 19:28:50.689 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMulticast.dll 01/07/2007 19:28:50.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMulticast.dll 01/07/2007 19:28:50.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMulticast.dll 01/07/2007 19:28:50.720 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsCommandDest.dll 01/07/2007 19:28:50.736 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsCommandDest.dll 01/07/2007 19:28:50.752 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsCommandDest.dll 01/07/2007 19:28:50.767 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileInserter.dll 01/07/2007 19:28:50.767 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileInserter.dll 01/07/2007 19:28:50.799 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileInserter.dll 01/07/2007 19:28:50.845 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileExtractor.dll 01/07/2007 19:28:50.845 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileExtractor.dll 01/07/2007 19:28:50.861 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileExtractor.dll 01/07/2007 19:28:50.877 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLineage.dll 01/07/2007 19:28:50.892 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLineage.dll 01/07/2007 19:28:50.908 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLineage.dll 01/07/2007 19:28:50.924 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxUnPivot.dll 01/07/2007 19:28:50.924 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxUnPivot.dll 01/07/2007 19:28:50.955 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxUnPivot.dll 01/07/2007 19:28:50.955 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponents.90.2047.0 E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxPivot.dll 01/07/2007 19:28:50.970 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMergeJoin.dll 01/07/2007 19:28:50.986 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMergeJoin.dll 01/07/2007 19:28:51.002 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMergeJoin.dll 01/07/2007 19:28:51.017 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponents.90.2047.0 E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxUnAll.dll 01/07/2007 19:28:51.033 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSort.dll 01/07/2007 19:28:51.033 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSort.dll 01/07/2007 19:28:51.049 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSort.dll 01/07/2007 19:28:51.064 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSplit.dll 01/07/2007 19:28:51.080 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSplit.dll 01/07/2007 19:28:51.080 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSplit.dll 01/07/2007 19:28:51.095 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLookup.dll 01/07/2007 19:28:51.111 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLookup.dll 01/07/2007 19:28:51.127 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLookup.dll 01/07/2007 19:28:51.142 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxGroupDups.dll 01/07/2007 19:28:51.158 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxGroupDups.dll 01/07/2007 19:28:51.158 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxGroupDups.dll 01/07/2007 19:28:51.174 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDerived.dll 01/07/2007 19:28:51.189 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDerived.dll 01/07/2007 19:28:51.205 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDerived.dll 01/07/2007 19:28:51.220 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDataConvert.dll 01/07/2007 19:28:51.236 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDataConvert.dll 01/07/2007 19:28:51.252 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDataConvert.dll 01/07/2007 19:28:51.267 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCopyMap.dll 01/07/2007 19:28:51.267 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCopyMap.dll 01/07/2007 19:28:51.283 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCopyMap.dll 01/07/2007 19:28:51.299 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCharMap.dll 01/07/2007 19:28:51.314 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCharMap.dll 01/07/2007 19:28:51.330 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCharMap.dll 01/07/2007 19:28:51.345 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxBestMatch.dll 01/07/2007 19:28:51.345 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxBestMatch.dll 01/07/2007 19:28:51.361 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxBestMatch.dll 01/07/2007 19:28:51.377 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxAgg.dll 01/07/2007 19:28:51.392 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxAgg.dll 01/07/2007 19:28:51.408 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxAgg.dll 01/07/2007 19:28:51.424 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.XmlTask.xml 01/07/2007 19:28:51.439 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5dtsBinnatchparser90.dll 01/07/2007 19:28:51.455 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.SQLTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SQLTask.dll 01/07/2007 19:28:51.470 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnSQLTaskConnections.dll 01/07/2007 19:28:51.470 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnSQLTaskConnections.dll 01/07/2007 19:28:51.486 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnSQLTaskConnections.dll 01/07/2007 19:28:51.502 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.SQLTask.dll 01/07/2007 19:28:51.533 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsSqlDest.dll 01/07/2007 19:28:51.549 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsSqlDest.dll 01/07/2007 19:28:51.580 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsSqlDest.dll 01/07/2007 19:28:51.595 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5SDKAssembliesMicrosoft.SqlServer.ScriptTask.dll 01/07/2007 19:28:51.595 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ScriptTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ScriptTask.dll 01/07/2007 19:28:51.611 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.ScriptTask.dll 01/07/2007 19:28:51.627 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRecordSetDest.dll 01/07/2007 19:28:51.642 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRecordSetDest.dll 01/07/2007 19:28:51.658 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRecordSetDest.dll 01/07/2007 19:28:51.674 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawSource.dll 01/07/2007 19:28:51.674 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawSource.dll 01/07/2007 19:28:51.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawSource.dll 01/07/2007 19:28:51.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawDest.dll 01/07/2007 19:28:51.720 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawDest.dll 01/07/2007 19:28:51.736 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawDest.dll 01/07/2007 19:28:51.752 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.ASTasks.xml 01/07/2007 19:28:51.767 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ASTasks9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ASTasks.dll 01/07/2007 19:28:51.783 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.ASTasks.dll 01/07/2007 19:28:51.799 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbSrc.dll 01/07/2007 19:28:51.799 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbSrc.dll 01/07/2007 19:28:51.830 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbSrc.dll 01/07/2007 19:28:51.845 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbDest.dll 01/07/2007 19:28:51.845 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbDest.dll 01/07/2007 19:28:51.861 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbDest.dll 01/07/2007 19:28:51.892 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileDest.dll 01/07/2007 19:28:51.908 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileDest.dll 01/07/2007 19:28:51.908 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileDest.dll 01/07/2007 19:28:51.924 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileSrc.dll 01/07/2007 19:28:51.955 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileSrc.dll 01/07/2007 19:28:51.955 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileSrc.dll 01/07/2007 19:28:51.970 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.FileSystemTask.xml 01/07/2007 19:28:51.986 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.FileSystemTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.FileSystemTask.dll 01/07/2007 19:28:52.017 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.FileSystemTask.dll 01/07/2007 19:28:52.033 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnExecPackageTask.dll 01/07/2007 19:28:52.049 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.DmQueryTask.xml 01/07/2007 19:28:52.064 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DMQueryTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DmQueryTask.dll 01/07/2007 19:28:52.064 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.DmQueryTask.dll 01/07/2007 19:28:52.095 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.BulkInsertTask.xml 01/07/2007 19:28:52.111 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BulkInsertTaskConnections9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTaskConnections.dll 01/07/2007 19:28:52.127 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BulkInsertTaskConnections9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTaskConnections.dll 01/07/2007 19:28:52.142 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BulkInsertTaskConnections9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTaskConnections.dll 01/07/2007 19:28:52.158 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.BulkInsertTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTask.dll 01/07/2007 19:28:52.174 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.BulkInsertTaskConnections.dll 01/07/2007 19:28:52.189 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.BulkInsertTask.dll 01/07/2007 19:28:52.205 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.WMIEWTask.xml 01/07/2007 19:28:52.220 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.WMIDRTask.xml 01/07/2007 19:28:52.236 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.WebServiceTask.xml 01/07/2007 19:28:52.252 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WebServiceTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WebServiceTask.dll 01/07/2007 19:28:52.267 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.MaintenancePlanTasks9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MaintenancePlanTasks.dll 01/07/2007 19:28:52.283 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.WebServiceTask.dll 01/07/2007 19:28:52.299 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.MaintenancePlanTasks.dll 01/07/2007 19:28:52.314 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesdtspipeline.rll 01/07/2007 19:28:52.330 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesdtspipeline.rll 01/07/2007 19:28:52.345 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesdtspipeline.rll 01/07/2007 19:28:52.345 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexceldest.dll 01/07/2007 19:28:52.377 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexceldest.dll 01/07/2007 19:28:52.392 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexceldest.dll 01/07/2007 19:28:52.392 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexcelsrc.dll 01/07/2007 19:28:52.408 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexcelsrc.dll 01/07/2007 19:28:52.439 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexcelsrc.dll 01/07/2007 19:28:52.439 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsMicrosoft.SqlServer.XMLSrc.dll 01/07/2007 19:28:52.455 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsMicrosoft.SqlServer.ADONETSrc.dll 01/07/2007 19:28:52.470 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.XmlSrc9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.XMLSrc.dll 01/07/2007 19:28:52.486 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ADONETSrc9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ADONETSrc.dll 01/07/2007 19:28:52.502 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.PipelineHost9.0.242.0__89845dcd8080cc91Microsoft.SQLServer.PipelineHost.dll 01/07/2007 19:28:52.517 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTSPipeline.dll 01/07/2007 19:28:52.533 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ForEachNodeListEnumerator9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ForEachNodeListEnumerator.dll 01/07/2007 19:28:52.549 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ForEachSMOEnumerator9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ForEachSMOEnumerator.dll 01/07/2007 19:28:52.564 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32DTEParseMgd9.0.242.0__89845dcd8080cc91DTEParseMgd.dll 01/07/2007 19:28:52.580 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32DTEParseMgd9.0.242.0__89845dcd8080cc91DTEParseMgd.dll 01/07/2007 19:28:52.595 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32DTEParseMgd9.0.242.0__89845dcd8080cc91DTEParseMgd.dll 01/07/2007 19:28:52.595 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinn.90.2047.0 E:MSSQLMSSQLSS2K5DTSBinnDTSComEx.dll 01/07/2007 19:28:52.611 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinndtsmsg.dll 01/07/2007 19:28:52.642 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTSLog.dll 01/07/2007 19:28:52.642 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinn.90.2047.0 E:MSSQLMSSQLSS2K5DTSBinnDtsUt.dll 01/07/2007 19:28:52.658 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTS.dll 01/07/2007 19:28:52.674 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinn.90.2047.0 E:MSSQLMSSQLSS2K5DTSBinnDTEParsM.dll 01/07/2007 19:28:52.705 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinn.90.2047.0 E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsNodeList.dll 01/07/2007 19:28:52.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsForEachFileEnumerator.dll 01/07/2007 19:28:52.720 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsForEachFileEnumerator.dll 01/07/2007 19:28:52.736 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsForEachFileEnumerator.dll 01/07/2007 19:28:52.752 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsMicrosoft.SqlServer.ForEachSMOEnumerator.dll 01/07/2007 19:28:52.767 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMsDtsSrvr.exe 01/07/2007 19:28:52.783 Failed to read version information for the following file: C:Program FilesMicrosoft.NETADOMD.NETenMicrosoft.AnalysisServices.AdomdClient.xml 01/07/2007 19:28:52.799 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft.NETADOMD.NETMicrosoft.AnalysisServices.AdomdClient.dll 01/07/2007 19:28:52.814 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.AdomdClient9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.AdomdClient.dll 01/07/2007 19:28:52.830 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedmsasxpress.dll 01/07/2007 19:28:52.845 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedmsasxpress.dll 01/07/2007 19:28:52.861 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedmsasxpress.dll 01/07/2007 19:28:52.877 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5ToolsBinnResources E:MSSQLMSSQLSS2K5ToolsBinnResourcessqlcm.xml 01/07/2007 19:28:52.877 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsBinnResourcesSqlManager.rll 01/07/2007 19:28:52.908 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsBinnResourcesSqlManager.rll 01/07/2007 19:28:52.924 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsBinnResourcesSqlManager.rll 01/07/2007 19:28:52.939 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsinnSqlManager.dll 01/07/2007 19:28:52.939 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsinnSqlManager.dll 01/07/2007 19:28:52.970 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsinnSqlManager.dll 01/07/2007 19:28:52.986 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsvcsync.dll 01/07/2007 19:28:52.986 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsvcsync.dll 01/07/2007 19:28:53.002 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsvcsync.dll 01/07/2007 19:28:53.017 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsecacctchg.dll 01/07/2007 19:28:53.033 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsecacctchg.dll 01/07/2007 19:28:53.049 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsecacctchg.dll 01/07/2007 19:28:53.064 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlftacct.dll 01/07/2007 19:28:53.064 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlftacct.dll 01/07/2007 19:28:53.095 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlftacct.dll 01/07/2007 19:28:53.111 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedisacctchange.dll 01/07/2007 19:28:53.111 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedisacctchange.dll 01/07/2007 19:28:53.127 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedisacctchange.dll 01/07/2007 19:28:53.158 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsvrenumapi.dll 01/07/2007 19:28:53.174 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsvrenumapi.dll 01/07/2007 19:28:53.189 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsvrenumapi.dll 01/07/2007 19:28:53.189 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerShared.90.2047.0 C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Rmo9.0.242.0__89845dcd8080cc91Rmo.dll 01/07/2007 19:28:53.205 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.DLL 01/07/2007 19:28:53.236 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataWarehouse.Interfaces9.0.242.0__89845dcd8080cc91Microsoft.DataWarehouse.Interfaces.DLL 01/07/2007 19:28:53.252 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.RegSvrEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.RegSvrEnum.dll 01/07/2007 19:28:53.252 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll 01/07/2007 19:28:53.267 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll 01/07/2007 19:28:53.299 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll 01/07/2007 19:28:53.299 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ServiceBrokerEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ServiceBrokerEnum.dll 01/07/2007 19:28:53.314 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WmiEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WmiEnum.dll 01/07/2007 19:28:53.330 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SqlEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SqlEnum.dll 01/07/2007 19:28:53.345 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SmoEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SmoEnum.dll 01/07/2007 19:28:53.361 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Smo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Smo.dll 01/07/2007 19:28:53.377 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedSqlSAC.exe 01/07/2007 19:28:53.392 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedMicrosoft.SqlSac.Public.dll 01/07/2007 19:28:53.392 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.msxml6_interop6.0.0.0__89845dcd8080cc91Microsoft.SqlServer.msxml6_interop.dll 01/07/2007 19:28:53.517 Attempting to install file: sqlrun_dts.msp 01/07/2007 19:28:53.548 Attempting to install file: \AUS02DB13g$2fe15a257eaedfc36c121fc912HotFixDTSFilessqlrun_dts.msp 01/07/2007 19:28:53.564 Creating MSP install log file at: C:WINDOWSHotfixDTS9LogsDTS9_Hotfix_KB913090_sqlrun_dts.msp.log 01/07/2007 19:28:53.580 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 01/07/2007 19:28:53.580 Failed to read registry key: Debug 01/07/2007 19:29:48.375 MSP returned 1603: A fatal error occurred during installation. 01/07/2007 19:29:48.672 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 01/07/2007 19:29:48.687 Failed to read registry key: Debug 01/07/2007 19:29:48.687 Unable to install MSP file: \AUS02DB13g$2fe15a257eaedfc36c121fc912HotFixDTSFilessqlrun_dts.msp 01/07/2007 19:29:48.703 The following exception occurred: Unable to install Windows Installer MSP file Date: 01/07/2007 19:29:48.703 File: depotsqlvaultsetupmainsetupsqlsesqlsedllcopyengine.cpp Line: 856 01/07/2007 19:29:48.750 01/07/2007 19:29:48.765 Product Status Summary: 01/07/2007 19:29:48.781 Product: SQL Server Native Client 01/07/2007 19:29:48.797 SQL Server Native Client (RTM ) - Success 01/07/2007 19:29:48.812 01/07/2007 19:29:48.828 Product: Setup Support Files 01/07/2007 19:29:48.844 Setup Support Files (RTM ) - Success 01/07/2007 19:29:48.844 01/07/2007 19:29:48.859 Product: Database Services 01/07/2007 19:29:48.875 Database Services (SP1 2047 ENU) - Success 01/07/2007 19:29:48.890 01/07/2007 19:29:48.906 Product: Integration Services 01/07/2007 19:29:48.922 Integration Services (SP1 ENU) - Failure 01/07/2007 19:29:48.937 Details: Unable to install Windows Installer MSP file 01/07/2007 19:29:48.953 01/07/2007 19:29:48.969 Product: Client Components 01/07/2007 19:29:48.969 Client Components (SP1 2047 ENU) - Not Applied 01/07/2007 19:29:48.984 01/07/2007 19:29:49.015 Product: MSXML 6.0 Parser 01/07/2007 19:29:49.062 MSXML 6.0 Parser (RTM ) - Not Applied 01/07/2007 19:29:49.078 01/07/2007 19:29:49.094 Product: SQLXML4 01/07/2007 19:29:49.109 SQLXML4 (RTM ) - Not Applied 01/07/2007 19:29:49.109 01/07/2007 19:29:49.140 Product: Backward Compatibility 01/07/2007 19:29:49.156 Backward Compatibility (RTM ) - Not Applied 01/07/2007 19:29:49.156 01/07/2007 19:29:49.172 Product: Microsoft SQL Server VSS Writer 01/07/2007 19:29:49.187 Microsoft SQL Server VSS Writer (RTM ) - Not Applied 01/07/2007 19:29:49.203
DML T-SQL works fine. But When I try to run SELECT query with joins that involves large tables (1.5 mil rows in each) in 2 databases, it instantly goes into "runnable" status and never finishes. It never finishes even when I have top 1 clause included. When I run insert or update that involves same tables, it works just fine.
Server facts:
W2003 SS 2K5 SP2 Db Comp level 90 (for all db) MAXODP = 1 (8 processor box)
Recently moved databases from server that had SS 2000.
When this query was running on box with SS 2000, it took about a minute to finish, but it completed.
I already tried: changing MAXODP settings, using OPTION (maxdop 1) etc.
I have installed SQL Server 2005 Enterprise Edition on a W2K3 server that already has a SQL Server 2000 default instance installed. The installation appears to be a success. The problem is that having installed the client tools, and trying to connect, I get the following error message in a dialog:
"Cannot connect server SERVERNAMEINSTANCENAME An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)"
The funny thing is that I can connect to the SQL Server 2000 default instance that is on that server. So it's obviously not a connection problem per se at my end i.e. bad dns etc which might stop me resolving the server name.
Googling for this error text gives the following advice on various web sites:
1. Check that the remote server allows connections.
It does, as other colleagues in my team have successfully installed the tools and can connect with no problems.
2. Check that the SQL Browser service is running.
It is, as without this running, my colleagues would not be able to connect either.
3. Open SQL Server Configuration Manager. Select "SQL Server 2005 Network Configuration | Protocols for MSSQLSERVER" then enable the protocols you need.
The required protocol (TCP/IP) is enabled. Named pipes is also enabled, although I don't think that we're using that. And shared memory is also enabled by default.
4. Open the firewall and add exceptions for sqlbrowser.exe or UDP port 1434
There is no firewall running at either end of the connection and as mentioned I can connect to the SS2K default instance.
5. Make sure that the server machine is reachable.
I can connect to the SS2K default instance so it must be reachable. I can't see that I would need to change any configuration settings as my colleagues are using exactly the same default settings for their connections and they work fine.
The only thing that I have done differently is that I originally installed the client tools using someone else's privileged account as I didn't have admin rights on my box. The client tools didn't work, so I got admin rights to my box, uninstalled the client tools and then reinstalled them using my account. Still no luck. Not sure if something is still hanging around after the uninstallation that would cause me a problem.
To help, I've also filled out the following questionnaire:
[1] Client side: > What is the connection string in you app or DSN? There isn't one. I'm trying to connect from the SQL Server Management Studio | 'Connect to Server' dialog. > If client fails to connect, what is the client error messages? "Cannot connect server Y An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)" Is the client remote or local to the SQL server machine? Remote Can you ping your server? YES Can you telnet to your SQL Server? YES What is your client database provider? [SNAC | MDAC | ADO.NET1.0 | ADO.NET2.0| other (please specify] N/A What is your client application? SQL Management Studio Is your client computer in the same domain as the Server computer? Different domains What protocol the client enabled? [Shared Memory | TCPIP | Named Pipes]. All 3 protocols are enabled Do you have aliases configured that match the server name portion of your connection string? No Do you select force encryption on server and/or client? No
[2] Server side: What is the MS SQL version? SQL Server 2005 What is the SKU of MS SQL? Enterprise What is the SQL Server Protocol enabled? [Shared Memory | TCPIP | Named Pipes ]. All 3 Does the server start successfully? YES. Other people can connect to the same instance. If SQL Server is a named instance, is the SQL browser enabled? YES What is the account that the SQL Server is running under? Domain Account Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? N/A. Firewall not running. Do you make firewall exception for SQL Browser UDP port 1434? N/A. Firewall not running. What tool or Application are you using to connect to SQL Server SQL Server Management Studio
[3] Platform: What is the OS version? Windows 2003 (Server side), Windows XP Pro Version 2002 SP 2 Do you have third party antivirus, anti-spareware software installed? Symantec AntiVirus
[4] Misc: If you have certificate configuration issue: N/A
Has anybody else come across this problem, as I've run out of ideas.
I need to create a 5GB database with 4GB for data and 1GB for log in v7.0. I know that in v6.5 I would have created five 1GB devices - to go easy on the backups.
Could someone please advise on how I should distibute allocation of space. Should I allocate 1GB to the primary files and 1GB each to 3 secondary files? Should I just allocate 4GB to primary?
I would really really appreciate any reponse? If there are articles I would appreciate links.
I have a small data warehouse which periodically has old data deleted. However after a delete the free space within the database is not released. If I copy the tables, drop them, recreate, and copy back, the space is there.
I was wondering, is there a way to allocate processors to SQL2000. I have a server that has 4 processors, I would like to leave one just for the operating system and have SQL2000 use the other 3. Is this possible and do you think it would be recomended to do this? Or should i just leave the 4 processors for everything?
I have one database with multipe MDF files.Normally when I am creating a new table it's going to primary MDF file.How I can allocate a new table to the MDF file which I am specifying when table is creating
I have windows 2003 with ms sql 2000. The machine has 3.6 gigs of ram and only runs ms sql, nothing else. Whenever the first query is made sql will allocate as much as 1.5 gigs of ram which is just killing the system. This system reboots nightly so this first query happens every morning. We have tried setting the min and max memory of sql, as well as the reserver memory setting to see if it will preallocate all that memory but we've had no luck.
Is there a way to make SQL allocate all that memory ahead of time? maybe make it cache some tables or something?
I know very little about MS SQL so please be very descriptive about possible solutions or troubleshooting steps.
can some one throw some light on how the DBAs calucaulate the space allocations?
For example I have 30000 records which has 30 columns each defined as varchar(100) and if the db is full and wants to increase the space. Then how much extrac space should be allocated??
How to find how much memory allocated to SQLCLR by sqlserver. Also is there any way to determine how much memory my code needs to run? Thanks in advance.
Any comments, please. I have a new server 5x160GB drives. It needs to run IIS for a web app and SQL Server 2005. One user database. I was thinking of dividing space as follows and wanted to get some thoughts from others.
On two different unrelated servers this week, I got these errors from a DBCC CHECKDB(tempdb):
Msg 8905, Level 16, State 1, Server NTSONYX, Procedure P_DATABASE_BACKUPS, Line 121 [Microsoft][ODBC SQL Server Driver][SQL Server]Extent (1:136752) in database ID 2 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
A re-boot solved the problem, but what is causing it?
During daily scheduled maintenance the following error occurs, which causes the maintenance job to fail. How can we fix? Thanks!
Allocation Discrepancy: Page is allocated but not linked; check the following pages and ids: allocation pg#=1085440 extent id=1085464 logical pg#=1085464 object id on extent=8 (object name = syslogs) indid on extent=0
I am getting the following error on a version 6.5 database when I run the weekly database backup.
"Allocation Discrepancy: Page is allocated but not linked; check the following pages and ids: allocation pg#=491520 extent id=491720 logical pg#=491720 object id on extent=8 (object name = syslogs) indid on extent=0"
The backup script I run is as follows.. SQLMAINT.EXE -D ECAP -CkDB -CkAl -UpdSts -BkUpDB F:MSSQLBACKUP -BkUpMedia DISK -DelBkUps 8 -Rpt F:MSSQLLOGECAP_DbBkUp.rpt
This database is a 7 x 24 database. What is the least intrusive and/or best way to correct this problem?
I'm log shipping to AWS. Currently, we are shipping from a server with 64 GB RAM to one at AWS with 30. It's not a massive server but does have periods of high usage when certain jobs/tasks run. It's been running fine for a year but the server size is large and is barely used. My understanding is that for simply log shipping, we don't need a lot of memory and I was hoping to drop the instance size down and use an instance with 16 GB Ram instead. It would save thousands per year.
I would like to ask regarding the memory allocation fo SQL Server 2000. For example if my Data Server have 8GB physical memory installed how much memory can SQL Server 2000 utilize? Based on my research and understing SQL 2000 Server can only utilize 3GB memory? But using the AWE you can set the memory to a maximum server memory?
I’m setting up a server for development that will have one instance of SQL Server 2000 Standard Edition and one of SQL Server 2005 Standard Edition installed.
The server has a total of 3.5 GB of physical memory, so I was wondering about the best way to allocate the memory. Should I just let both instances have the default allocation and let them fight it out for memory as needed, or allocate a memory limit for each instance?
I am setting up a server under Windows Server 2003 Enterprise Edition (SP1) and SQL Server 2000 Enterprise Edition (SP4). The new server is a AMD opteron with 32 GB of memory. I noticed that PAE is enabled automatically by Windows 2003. Should I enable AWE for SQL Server 2000 and specify Max and Min amount of memory for SQL Server ?? Is there a limit on how much I could specify in MAX memory for SQL??
This is the first time I have a server with so much memory so I want to make sure that I do the right thing. In the past I only have servers with 8 GB of memory and we just enable AWE and specify Max memory to 6 GB or so.
I wanted to know on what basis the disk space allocation for the databases is planned . Suppose if we plan 60 GB for data files ( mdf )for a given database then what should be the space allocation for the log files ( ldf ) and the tempdb ( both mdf and ldf files ).
Is there any thumb rule or any defined ratio for the same ?