BKGarry

So I was casually browsing the BETT website and spotted this https://www.bettshow.com/whats-on/the-escape-room I think we need some EduGeek teams for this!!!! I have practice of Escape Rooms by the way, as we have quite a few in our town run by one company, and they do get addictive.

HP Stream Pro 11 G4 EE hardware IDs you have to disable both ACPI\VEN_HPQ&DEV_6001 HID\VEN_HPQ&DEV_6001

HP Stream Pro 11 G4 EE hardware IDs ACPI\VEN_HPQ&DEV_6001 HID\VEN_HPQ&DEV_6001

I have passed it back to our LA support. I bet something has got lost in translation over to Capita. To be honest, I'm not as worried now as I haven't has any massive massive jump since but still a very strange thing to happen IMHO

Email sent to LM, as being Deputy Head, he is always one step ahead in the school than I seem to be. As I have to book my days for BETT as well.

"All your hugs are belong to us"

CPD: hug training

I'll speak to my LM tomorrow, let me find the CPD blurb lol

@elsiegee40 I haven't yet! I don't know if I can make it yet, I have to speak to my Line Manager, as all our students start back on the 3rd January!

I am afraid Classcharts writes back behaviour and achievement and that is not it. Now files, that is an interesting one, although it wouldn't be 7mb per student, we have had people scanning in old data collection sheets, but I thought that would go to the document server

Thank you @vikpaw I am going to wait and see what I get as a response back. After reindexing it doesn't seem to be that bad, they also said that there is not any one table or area where it seems to be using all the space. It is just a massive balloon on that one day that doesn't seemed to have happened again. I have two pieces of software with writeback functionality, one is Salamandersoft's AD sync, which writes back email addresses only and the other is classcharts, and I checked there, and there wasn't a mass amount of data. I am very confused.

@splattthecat We very rarely use discover (we have 4Matrix for that) and I can confirm that change management is turned off

So Capita have had a remote connection to our server and have said that our DB size if perfectly fine for a school of our size :-/

FYI, reducing the log file did not do it! This is going to be a mystery, capita may see something though :-)

And here is the great mystery, restored the older MDF and LDF onto a different server (the LDF is 75GB!!!!!!) ran the same query and there is around 100mb difference in the top tables all together, and no difference on the ASM one. I am now executing a backup and a shrink of the logs on the restored one, to see if I can get the same effect

nope, this happened before the reindex patch, and no updates applied.

We have InTouch and Lesson Monitor. I think these are a legacy thing from when they used to give every child a target grade for every subject and then deleted the ones for the subjects they are not in

Ticket is being raised with capita and copy of the database going that way,

In MB 1. asm_result_tpa_delete - 3766 2. itc_message_out - 1009 3. itc__message_out_attachment - 1006 4. db_audit_header - 988 5. att_lesson_mark - 849

That is a good idea, I am on 24gb today, log file isn't increasing as bad, that does make sense though. Yay a fresh set of eyes.

I don't think that is the case, it is quite hard for them, they have had their team cut from 10/12 people to 3 in recent months. The "reshuffle" has made it hard from them. With this I would really want them to go, we will take a copy of the DB and send it to capita. I am thinking about loading the DB from backup onto a different SQL server and run the largest table report again and see if I can see the differences there but that is a big job and needs to be done carefully I feel

Update, Local Support Unit have said they are researching this and that they will call back on Monday. They do not have a copy of my data, so I wonder how they're going to do that

nohuge huge, we are talking 3,766mb so it could be part of it, but not all of it

@jthompson that wasn't a bad shout. I have just ran the following SQL Script/Query SELECT t.NAME AS TableName, i.name as indexName, sum(p.rows) as RowCounts, sum(a.total_pages) as TotalPages, sum(a.used_pages) as UsedPages, sum(a.data_pages) as DataPages, (sum(a.total_pages) * 8) / 1024 as TotalSpaceMB, (sum(a.used_pages) * 8) / 1024 as UsedSpaceMB, (sum(a.data_pages) * 8) / 1024 as DataSpaceMB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id WHERE t.NAME NOT LIKE 'dt%' AND i.OBJECT_ID > 255 AND i.index_id <= 1 GROUP BY t.NAME, i.object_id, i.index_id, i.name ORDER BY SUM(a.total_pages) DESC I have just found the following tables by row count: No. 5 - ASM_Result - 3,162,840 - Rows No. 4 - att_mark_hist_normalised - 3,325,224 rows No. 3 - att_lesson_mark - 10,476,308 Rows No. 2 - att_mark_normalised - 13,940,344 Rows and the massive jump to number 1: asm_result_tpa_delete: 90,630,006 rows that is 90 million rows!!!!!!!! Can't wait for a call back this morning

We do have InTouch. But only 20 emails that day. 102 SMS messages. I thought that too.