Hello and welcome to my guide
In the first section of this guide, you can read about some tips to increase your connection quality (if your infrastracture / ISP allows it). Then you will learn about console ping measurement and how to determine your max acceptable ping value and which server hubs you can land on.
Lets dive in...

1.Make sure game files are not corrupt
I know This may look silly but it is a good idea to rule out file corruption. as you may know, file corruption is the source of many unwanted and erratic behaviors in not just CSGO but any other games too. Verify your game files.

2. Update your network drivers
Visit your network card's manufacturer website and download the latest drivers and install them.

3. Have decent bandwidth
Fortunately the game is not demanding, considering that nowadays, quality service is not scarce. As a bare minimum, make sure you have 512 kbps of bandwidth, as less than that might lead to delayed packet transmission.
You can set your bandwidth amount in the CSGO settings.

4. Wired Connection is preferred
To minimize the chance of interference, consider using a wired connection instead of a wireless one.
If you use wireless connection, make sure that interference causing items (cellphones,metallic items or items using 2.4Ghz / 5 Ghz frequency band) are away from your router. Also decrease the distance between your router and your PC as much as possible.

5.You can't manually ping servers
Apparently, Valve has hidden the server hubs ip addresses to prevent DDoSing attempts, so manual pinging (via Command prompt) is out of hand. SteamDB's github repository has the file which is over 2 years old, thus unusable. (credit goes to CSGO reddit for this point)

6.Prevent your system from hogging bandwidth
To avoid ping spikes on your end, this point is of utmost importance.
You might not be aware but as you connect to the internet, your system establishes connections automatically in the background (sevices, download managers, Windows update, etc.). Also do not share a router connection with family / friends while playing. If you have downloads running, stop / pause them before playing. You should use firewall softwares to fine-tune which application has the right to connect to internet and which doesn't. You can then set rules to only allow urgent system components, steam and CSGO to establish connections to the internet.

Here are the options:
A. get an anti-malware package that comes with a built-in firewall.
B. get a free/ paid firewall application.
C. Use windows built-in firewall to set rules.

Here is the screenshot of my firewall application set-up for CSGO. The application name is Glasswire, which is a paid firewall app.


In this screenshot, you can see that I made a profile for Counter-strike games and white-listed Steam, CS executables (1.6, Source and Global Offensive) and Windows kernel + another urgent service.

!!Note!!
A. I use windows 8.1 so there is a chance that you add maybe a couple more services to your white-list if you use Windows 10. There is nothing wrong with that.
B. I am *NOT* affiliated with Glasswire inc. This screenshot merely serves the purpose of an example for white-listing your apps.
C.You can google for some free alternatives.

7.Prevent Steam from downloading updates while you are in-game
Go to steam settings (upper left side of your steam clients) . Click on downloads tab and uncheck "Allow downloads during gameplay."

After joining a match, if you run "status" command in console, it returns for example "EU west" or "EU east", which is not really useful if you want to narrow down your server hub location. For that reason check the following:

1. Make sure your router and connection to internet are OK and that there isn't a download
going on in the background. Also make sure that you do not share your router with family
members while playing. *Best approach is to restrict any background connections as explained in the Tips section

2.enable the developer console

Run the game. In main-menu, click settings and then click on game tab. enable the console
using the drop down menu. from now on you can call / close the console by using the
defined console key (default tilde key which is "~").



-Call the console; You may see the line: "Ping measurement completed" followed by "Ping
location"
if not, no problem. Close the console anyway.



3.Test the connection

- Go to play tab in the main-menu, go to Competitive or Wingman tab, proceed with choosing
a map and click on the green "GO" button.


immediately open up the console and wait a few
seconds so that the ping measurement is done and a list of server hub locations is shown
followed by sorted out optimal ping locations. when you see this close the console and
stop the matchmaking process so that you do not start a match unwillingly.



!!!NOTE!!!
You can repeat the above step a few more times so that the possibility of ping spikes
leading to wrong numbers gets minimized.



- The list of hubs in your console (pictured above) shows your latency (upstream and downstream) for each
hub. Naturally the hub that is closer to your location, provides lower latency.

!!!Note!!!
-----------------
Don't mind the big numbers in the screenshot, yours will naturally be much lower for your nearest server(s)

4. choose the best hub based on upstream (ping) value.

For example:

- After the testing , the player sees these values in the console window. (These numbers
are made up by me for tutorial purposes.)

Ping locations:

Par: 23/6 Fra: 28/8 Ams: 45 /10 Sto: 52 /13 Waw 82 / 18 etc.

A) If you want to force the game to choose the server with the lowest ping , you should
choose the value lower than the amount for the next server in the line yet not the same
amount as the desired server. for example the value should be lower than 27 or 28 but
higher than 23. 25 is a good choice. this way the matchmaking system only searches for
games on the Paris Hub. Searching on 1 hub lengthens the queue time and reduces the chance
of finding a match.

B) It is a good alternative is to choose the range of 2 or 3 servers .
In the above example, I would want to play on Paris or Frankfurt servers but not on the rest of them so I choose an amount higher than "Fra" ping and lower than "Ams" ping. for example I choose 33. now this orders the game to find games on servers with an upstream latency of 33 or lower which means Paris and Frankfurt servers.

C)If you have a good connection and/or close proximity, it is more probable that you get low pings to the extent that makes it hard for you to pin the number of a single server hub. in that case, go with point B.

After you settled on a number, enter it in the correct field and press enter.




Here is a list of Hubs and their real locations:

ams = Amsterdam ---------- par = Paris
lux = Luxembourg ---------- lhr = London
vie = Vienna ---------- iad = Sterling
sto = Stockholm ---------- lax = Los Angeles
waw = Warsaw ---------- ord = Chicago
mad = Madrid ---------- okc = Oklahoma City
Fra = Frankfurt ---------- sea = Seattle
syd = Sydney ---------- eat = Moses Lake
gru = Sao Paulo ---------- atl = Atlanta
scl = Santiago ---------- hkg = Hong Kong
dxb = Dubai ----------- sgp = Singapore
bom= Mumbai ----------- jnb = Johannesburg
Maa = Chennai ---------- sha = Shanghai
lim = Lima ---------- can = Guangzhou
man = Manila ---------- tsn = Tianjin
tyo = Tokyo---------------eze = Buenos Aires

Note: You can use the site http://steamstat.us to check on server' load and status.

I hope you have enjoyed reading this guide. It is an attempt to help fellow counter-strikers, even a little bit. Remember, connection issues are diverse in nature and thus somewhat hard to fix 100%.
In case you run into problems in other areas, I have linked these four guides below, written by my friend Berend. These are guides revolving around the more common problems regarding CSGO.


https://steamproxy.com/sharedfiles/filedetails/?id=1907675935

https://steamproxy.com/sharedfiles/filedetails/?id=2203518412

https://steamproxy.com/sharedfiles/filedetails/?id=2203437337

https://steamproxy.com/sharedfiles/filedetails/?id=1911087875

This guide comes to an end here. I hope I could be of help.
stay safe and happy!! :D