Subscribe To Our Newsletter
If you are looking at data connections, you will come across the term leased line. However, there are many people who do not understand what a leased line is or what it has to offer. If you are in the market for a data connection, you need to understand what this is, what it can be used for and the limitations that you will face with this connection.
A leased line connection is also known as a dedicated line. As the name suggests, this line will connect 2 locations for private data and voice communication. The leased line will have a fixed-bandwidth and symmetric data connections.
When you have a leased line connection, you will be the only one using the bandwidth on offer. The connection will always be available to you and you will not have to worry about traffic on the connection. It is important to note that the leased line will only link 2 locations together such as your headquarters and another corporate office for your business.
What Is A Leased Line Used For?
The leased line connection is generally rented by businesses to connect two corporate locations. This is due to the fact that the guaranteed bandwidth will ensure that there is seamless communication between the offices. This is something that you might not be able to obtain when you are using a regular line connection.
The leased line will be able to carry an internet connection as well as phone calls. PC and server links can also be achieved with these line connections. However, it is important to note that high-speed internet will generally not be the best use for these connections.
Leased Lines Do Not Automatically Provide An Internet Connection
While most companies will purchase their leased line at the same time as their internet access, they are not the same thing. This is very important because it will impact the services that your business will need to obtain. It also means that there is no requirement that your leased line also be the line that provides your internet connection.
If you are going to get internet on the leased line, you do not have to fill the bandwidth. It is possible to purchase internet access that will only use a fraction of what your leased line is capable of. An example of this will be purchasing internet access of 15 Mbit/s for a leased line that offers 20 Mbit/s. This is actually recommended if you are going to be getting internet access because you will be able to leverage the remaining bandwidth for other aspects of your business.
The Cost Of The Leased Line
While leased line connection costs have fallen over the last few years, they are still a major concern for new businesses. If you are looking for an internet connection, a standard connection will be cheaper and you need to consider this. ADSL connections are much cheaper than leased lines and will often provide you with the internet speeds that you need for your business. However there are some great tips of saving money on your bandwidth if you’d like further information and advice.
When we are asked by a client to do some SQL Server Consulting a lot of the time what we are asked what we can do in order to improve the performance of a SQL Server. So we thought we’d put together some advise to help you out in you are in a similar situation.
How To Speed Up A SQL Server
There are times when your SQL server will appear to be slow and you need to adjust this. If you are the administrator of the server, there are a few methods that you can use to do this. Of course, it is important to note that not all of these methods will work for every database and it will depend on what has been placed on the server.
Use The SET NOCOUNT ON
When you have a stored procedure in your SQL database, there is a default which is used. This default will send a message from the server to the client telling them about the number of rows that will be affected by the stored procedure. This message is not actually necessary and will generally add nothing to the client side of things. What it will do is slow down the server.
When you turn off this default setting, you will be reducing the network traffic between the server and the client. As this information is rarely needed, there is no reason to not do so. To turn off the default feature, you will need to use the SET NOCOUNT ON statement in all of your stored procedures.
This statement will need to be included at a stored procedure level and cannot be applied to the server as a whole. The statement will need to be included at the start of each stored procedure that you write.
Do Not Use The SP_ Prefix
When you create a stored procedure that will run in a database that is not the Master one, you should avoid the prefix “sp_”. This is due to the fact that this prefix is specifically used for system stored procedures. This does not mean that the procedure will not run, it simply means that the execution will be slightly slower.
The reason for the delay in execution is the fact that procedures with this prefix are first attempted to be resolved from the Master database. As the procedure is not located there, the server will waste time looking for it. When the procedure is not found in the Master database, the server will resolve it as if the owner of the object is “dbo”. This is an unnecessary delay which can slow down the server drastically if it needs to be completed multiple times.
Adjust The Minimum Memory Per Query Setting
When you have a query running on a Microsoft SQL server, the server will allocate the optimum amount of memory to the task. This ensures that the query is run quickly and efficiently. The default for this will be 1024 KB per query and this is the minimum amount.
If you have a query which needs more memory to run, the server will automatically assign the memory if it is available. As this is the case, most people will recommend not changing the default setting for the minimum memory per query. However, if you have a SQL server with more RAM than it actually needs, you can boost the performance of certain queries by adjusting this minimum default.
To boost the query, you will need to increase the minimum which is set to around 2048 KB or more. As long as there is an excess of memory on the server, the boosting will help the overall speed of the server. The problem comes when there is no excess as the higher minimum will slow down the server.
This is why this adjust is not often recommended and you need to be very careful when you choose to use it. Before doing this, you need to ensure that your server has more RAM than it actually needs and that there will always be an excess even with the higher minimum amounts.