SQL Server Stack Dump and Individual data file sizes

[Osman84]

Hi all,

I am a database programmer and used the SQL server 2005 for database handling. I want to know Hew to stack dump in SQL Server? Also I want to know that is there a way to measure individual data file size of a database? Please help .Thanks in advance.

[MindSpace]

SQL server have records Database. In Startup, shutdown and run the activities during the background processes, such as table space to create, create rollback segments, some of the alter command, log switch, error messages and so on. Failure in the database, first view the article Pieces, but the file information and any error conditions are not necessarily linked. Background alarm log file BACKGROUND_DUMP_DEST parameter specifies the directory file format SIDALRT.LOG. Check that and reply.

[Zecho]

SQL server offers a class of command, can be the internal structure of Oracle types of information contained in the dump (dump) to the trace file so that users can be resolved according to the document the various faults. Set up There are two ways to track events, one is to set the event in init.ora file, so open the database, it will affect all sessions. Set the following format:
"eventnumber trace name event name [forever,] [level level number]: .......". By symbols, you can set the number of consecutive events, you can also use the event to set the number of consecutive events. All the best.

[opaper]

Check the \ Bin folder for the SQL Server installation SQLImage.dll and DBGHelp.dll rename the file a different file name. If you are a Microsoft Windows 2000-based computer that is running, perform this step is sufficient to avoid the problem. If you are a Windows NT 4.0-based computer running, you must also file Imagehlp.dll and DBGHELP.dll replace% Systemroot% \ System32 in the files from the copy of Windows 2000. All the best.

[Reegan]

To resolve this problem, determine the existence of the database will be inconsistent, and then resolve the inconsistent position. To do so, follow these steps:

1. SQL Server instance on the failure of all the databases running DBCC CHECKDB TRANSACT-SQL command.
2. If the DBCC CHECKDB TRANSACT-SQL command reported the error that the database to resolve these errors are inconsistent.

[absolute55]

SQL Server to perform certain run-time checks, can help, it indicates a problem, you may need to take corrective measures. These inspections are called assertions. When the failed assertion check SQL Server do the following:
1. SQL Server that assertion fatal error.
2. SQL Server 3624 error message in the application of information back to the assertion.
3. Generated stack dump file as a SQL Server perform the following steps:
1. SQL Server writes the stack dump file and the $ to assert SQL Server error log file detailed information for more information.
2. SQL Server to create a mini dump file.
3. If SQL Server is configured to use error reporting, SQL Server will send the file to Watson error reporting site.
4. SQL Server client applications and the end of the connection.