Why is Lag ? Dedicated intel xeon 3.40 24 GB Ram :(

[okulyolu]

Originally Posted by Phoenix 1337

It's free :| . Its the best DDoS Protect program which is free at the moment.

kiwiguard active.. What other programs ?

[sarkoplata]

If you don't have SSD -> LAG
Or that Unique tool (i think it's unique logger) maybe causing that CPU usage, if circle doesn't have a moment to rest the cpu)

Turkish for you (türkçe)

 Spoiler

SSD kullanman lazım SATA II diskler lag yapar, yeteri kadar hızlı değil
Resimde sol altta görev çubuğunda gördüğüm unique programı CPU kullanımını çoğaltıyor olabilir... DDOS olsa o hosta öyle giremezsin.

[pushipu]

From my experience to have no lag (sure if you are not under attack) you have to use SSD, I have run 1000 online with a i5 8GB Ram + 2nd server QuadCore 9600 with 4GB Ram, with SSD and no lags at all.
So you can trow away all this this Xenon Opteron with 100500 GB Ram, it doesn't help you with anything.

[Schickl]

A good HDD easily gets to 150MB/s writing speed.
That's more than enough, even with all the stuff it has to read at the same time

As long as you don't have to share it with other people

[Nezekan]

Originally Posted by Schickl

A good HDD easily gets to 150MB/s writing speed.
That's more than enough, even with all the stuff it has to read at the same time

As long as you don't have to share it with other people

there is a difference between sequential read and random io operations, especially for database

[Schickl]

Originally Posted by Nezekan

there is a difference between sequential read and random io operations, especially for database

I am aware of this

HDDs still keep over 100MB/s(most)

The SQL Server optimizes writing/reading as well to keep the performance as high as possible

OP should monitor the HDD(windows has tools for this as everyone should know) and the other components
That should help finding the cause

[theross]

Wait a minute... Xeon CPU, only 2 Cores / Threads?
Is that a virtual machine?
Xeons do not have 1 (or 2) cores.

Intels ARK says:

# of Cores 4
# of Threads 8

Why is your task manager showing only 2?

[Schickl]

Originally Posted by theross

Wait a minute... Xeon CPU, only 2 Cores / Threads?
Is that a virtual machine?
Xeons do not have 1 (or 2) cores.

Intels ARK says:

Why is your task manager showing only 2?

Noticed this as well

Either the cores are disabled(I highly doubt this) or it's running in a VM

That might be the problem(or better: reason)

[theross]

You can't disable a certain number of cores (afaik).
Either disable multicore or Hyperthreading. None of both would lead to 2 cores.

IF you are running it on a VM -- Install the database engine on the main OS outside the VM!

Besides that you may want to uninstall the sql server DEMO called "Express" due to its limitations in RAM-usage (max 4GB for buffering), CPU-Usage (Only 1 Core) and DB Size (4gb raw data)) and switch to an enterprise version. And don't use any 2012 version or something - On these services, sentences like "the newer - the better" are completely wrong.

[batuxp123]

Bad connection (100mbit not limit / 1gbit port) facepalm.. upgrade your network 1gbit unlimited.

[sarkoplata]

Originally Posted by batuxp123

Bad connection (100mbit not limit / 1gbit port) facepalm.. upgrade your network 1gbit unlimited.

totally useless.. 100mbit is much enough for a sro server.

[Schickl]

Originally Posted by theross

You can't disable a certain number of cores (afaik).
Either disable multicore or Hyperthreading. None of both would lead to 2 cores.

IF you are running it on a VM -- Install the database engine on the main OS outside the VM!

Besides that you may want to uninstall the sql server DEMO called "Express" due to its limitations in RAM-usage (max 4GB for buffering), CPU-Usage (Only 1 Core) and DB Size (4gb raw data)) and switch to an enterprise version. And don't use any 2012 version or something - On these services, sentences like "the newer - the better" are completely wrong.

Of course it's possible to disable the cores("disable"; you can tell windows to use less)


And SQL Server Express is limited to 1GB RAM and 10GB DBs

[Haze*]

Originally Posted by Phoenix 1337

It's free :| . Its the best DDoS Protect program which is free at the moment.

Yeah, except for the fact that it's okay if the attacks are coming from like what, max 10 IP adresses? These "ddos protection programs" are as useless as these mystical entities you blind people call gods.

Originally Posted by okulyolu

kiwiguard active.. What other programs ?

Stop using that bullshit and pay for a hardware protection if you want to be safe.

[鳳凰城]

Originally Posted by Haze*

Yeah, except for the fact that it's okay if the attacks are coming from like what, max 10 IP adresses? These "ddos protection programs" are as useless as these mystical entities you blind people call gods.



Stop using that bullshit and pay for a hardware protection if you want to be safe.

In fact, This **** software in your eyes works better than many offers for DDoS hardware protection nowadays. Lets be honest.. Hardware is the best for those who have money to waste.
Botnet DDoS could be secured by many ***** that you may do not know in windows 2000 and older versions.

[Mykha*]

Do you use the log database? if you do, what is the current size of the log db?