Question/Suggestion dedicated to a Administrator

Status
Not open for further replies.

Nic

I think, therefore I am.
Joined
December 29th , 2010
Messages
3,196
Reaction score
4,794
Age
34
Location
Germany
Is it possible to delete those accounts
who didn't logg in for a special ammount
of time? Like since the last 2 or 3 years.

The sense of this suggestion is to
make the database more stable
also with it the connection.

We would clean the database capacity
and make some new place for the RAM.
 

RESiSTANT

Server Owner
Joined
February 1st , 2009
Messages
20,872
Reaction score
60,459
Location
Europe
It's possible and I have did it before. Our current usage of ram is 58% from 100%. Our current ram installed is 24gb. MSSQL uses 16 GB for max performance. Only 6GB is used so far by the MSSQL. So we have like 10 GB which means many years to come to start deleting inactive accounts.

MSSQL is the program that handles all database procedures.

Our machine right now is more than that we need to host for. So it's not the database or machine performance cause for the lag you experience.

Our CPU usage is like 20-30% at days and up 50% at nights, depends on the user activity. If something is need I'm upgrading the machine at the moment. I won't let the server lagged.

In this situation I think it's about user to server connection. Anyway I'm working out for bigger bandwidth connection.. up to 2 Gbit/s or 3 Gbit's or maybe 4. Current one we pay is for 1gbit/s (1000mbps).
 

Nic

I think, therefore I am.
Joined
December 29th , 2010
Messages
3,196
Reaction score
4,794
Age
34
Location
Germany
I'm enlightened great news, any mod can close this.
 
Status
Not open for further replies.
Top