Recently i had a customer which had outgrown the SQL database size limit in SQLEXPRESS.
Not the hard drive size.
This caused the MIVCR software to start deleteing PVD’s!
We had to move the DB’s from SQL Lite to Full SQL
Continue readingSQL
Micontact Centre Sql known issue V7.1.1.1. Table filling database. Reports empty.
Problem:
All reports show as empty. SQL DB shows as full
Solution:
There is a known issue in version 7.1.1.1 where one table starts growing very large
You can check if yo have this problem by checking the disk usage in sql
If you see the Pie chart showing the database file as all purple then check the disk usage by table
What i then did was read the contents of this table with this SQL command
You can leave off the “Datekey” command. This will show you everything in the table. What i saw is that one day millions of entries while other days had a few thousand. I deleted that day and the SQL DB usage dropped by half
Then re-summarize the data into the SQL DB month by month check the size as you go. If it does go large again repeat the commands and find the offending day/time.