Why AS2000 generate lot SQLDmpr.mdmp files | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Why AS2000 generate lot SQLDmpr.mdmp files

My Analysis service 2000 used work fine. But recent days it generates lots SQLDmpr###.mdmp files. What are they?
My process cube takes much long time than before. Thanks for help!
George

Try to identify the last cube(s) being changed and delete them directly in the OLAPDATA directory (must delete the corresponding
“.odb” file and directory).
Also one way to fix this would to do a full rebuild of your OLAP Database. You would need to take a backup of the Data folder and then delete all the files in the data folder so that you could get the service to start up without crashing.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
What service pack do you have installed on AS? The .mdmp mini dump files are generated when the system reboots you can read the contents of this file using a dubugger (windbg.exe) but if you dont have much experience debugging these files it could be very time consuming. Do you get any processing errors? Raulie
This is AS2000 with SP4 installed.
Still keep getting the error from the server event viewer: "The MSSQLServerOLAPService service terminated unexpectedly. It has done this 415 time(s)."
and "Unexpected fatal error occurred. Attempting to restart server."
This is the first time I see this kind error. Re-install old backup has to reprocess all cubes which will take quite long time.
Thanks for help.
See this KBAhttp://support.microsoft.com/default.aspx/kb/328876 is any help for that restart. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |