Advertisement

add

Wednesday 12 November 2014

Some Ways To Improve The SQL Server Performance

There are some of various ways and by adopting them we can inhance the sql server performance . Some of them are as follows :

Improving SQL Query


SQL queries could be written in many ways but a developer should have to use the bet queries to make the performance more better.

Prevent to add multiple function in a single query:

Various function such as email article printing sharing should be avoided to be done by a single query.
This could increase the load of database query and inccur increment in process timing. To avoid such jargon try to use different queries for different purposes. or  to avid this issue the nested loop joins could be used.

Avoid to use Cursors in Query

Just avoid to use cursors in queries because the set based queries are much better. If the cursor is needed in queries then at that situation try to avoid dynamic cursor which limits the use of nesed loop joins by optimizer.

Avoid Multi-statement functions (TVFs)

These inline are less costly than the multi statement functions. The inline TVFs is being expand by server into various main query and also seperate the context
from main query. which makes TVFs very costly.

Include indexes :

Indexed table always reduce the interval timing of data but this also effects on DML operations adversly. This also be decrease theperformance of queries.
Indexing is type of challenge but its a fact that  it improve the perforance of sql queries and also improves the query timing.

Understand the Data

By understanding the data type we can identify the type of queries to be used to retrieve the data. After creating the database when data entered sucessfully and
when indexing be done properly this desicion should be took carefully that what types of queries should be used their to retrieve the data. If their is a need then
mention a unique key which leads the query. To avoid any type of overhead just one should have to choose the coloumn correctly and make appropriate changes.

Include coloumn in index
Include coloumn in indexed table is important because it helps to improve the performance o sql queries. By including coloumn in table helps queries to search
data very easily without searching the whole database due to which the sql query performance improves. When the required content matched with the content of
a coloumn its can be easily retrieved. when the database in not properly indexed or coloumned then it also creates very much difficulties to retrieve the data and
also creates very much overload on sql server.

Delete useless indexes :

Deleting useless indexes decrease the size of database due to which the sql load also decreases and the data retrieval become less time taking. Which just
speed up the sql performance and data modofication. The small size of database also helps to decrease the overhead use of server resources.

Regular Updates :

There must be a regular updation is needed for coloumns as by optimizing the coloumns done by queries. Regualar updates also inhace the quality of queries.

Include som special keys :

By inclusion of some keys such as NOT NULL , FORIGEN KEY, PRIMARY KEY etc also improves the sql sever performance. 
Recent Tags : About Some Ways To Improve The SQL Server Performance, Some Ways To Improve The SQL Server Performance Details, What is Some Ways To Improve The SQL Server Performance Knowledge of Some Ways To Improve The SQL Server Performance, Some Ways To Improve The SQL Server Performance

No comments:

Post a Comment