I wasn't sure where to post this, sorry if it belongs elsewhere.
To help you with the bigger picture, I'm an MCDBA and I am currently working in tech support for a Progress database.
I use MS Dynamic CRM 3 at work and it is really slow. I read through a Microsoft CRM performance paper and started checking. I have what seems to be an admin password and finding the SQL and CRM servers was easy.
In the registry of the CRM server in LM>software>Microsoft>MSCRM , there are two values, metabase and database, with the server name and the initial catalog, so I have the database paths. Let's forget about the metabase.
The mdf is 2.5 GB and the log 500MB. Here's my question. the modified date of the log file updates every now and then although it can be off by hours, even if I create a case in CRM! The mdf file is dated Aplir 11, 2007. This is what is being backed up everyday and all the system clocks are correct to the day and minute.
I plan to show the sys admin where the problems with CRM are coming from after I complete my investigation and help him, but this phenomenon with the modified date has thown me for a loop.
Incase the keys I looked at in the registry weren't the right ones, I searched the computer for .mdf files. All but the one in the value database's data are very very small and all have older modified dates. the metabase mdf and ldf update regularly. SQL is installed on the CRM server for the Reporting Services only.
If you need more info, hopefully I can get it.
Thanks,
Jeff
The time stamps on the physical files will update at random. The date/time stamp which is shown doesn't update when ever data is added to the files.
Have you rebuilt the indexes, updated stats, checked profiler for long running queries, etc?
No comments:
Post a Comment