Wireless tables exploded in size

Question

With NPM12, a re-architect of our wireless network, and the start of the academic year a couple of the tables in our database have exploded in size:

TableNameRowCountsTotalSpaceMBUsedSpaceMBUnusedSpaceMBWireless_Interfaces_DAILY15008766321109311073253605Wireless_Clients_DAILY981112272110171109801370Wireless_Clients_SessionHistory55387162449763484661297

yep, we have over 270GB of wireless data that I am unsure of what its purpose is.

this seems quite large for unpartitioned data tables.

Anyone know what the purpose of each of these tables is?

Anyone else seen these tables explode to this size?

if I don't need the data in the tables, any issues with simply truncating them?

(I've opened a support case on this )

Thanks

Richard

Karthik.A · Answer

Hi @[Deleted User] / @RichardLetts ,

Did you get any solution for this?? Can you please sugggest what can be done here..

Thanks!

dkobrosly · Answer

Anyone still seeing huge wireless tables in their environment? I scaled back the wireless retention settings from the web console, but the tables still remain the same size..I see this causes a lot of blocking on the sql side, since the table is so large.

Wireless_Interfaces_DAILY - 148061199

Wireless_Clients_DAILY - 28569775

Wireless_AccessPoints_DAILY - 13052786

dkobrosly · Answer

Hi Richard,

Were you able to find anything from support regarding the size of your Wireless_Interfaces_DAILY table?

I just noticed ours is quite large as well..

Table Name                  Rows                  Size in GBS

Wireless_Interfaces_DAILY 119814386  34