Guidelines and advices about Data Server

Asked By 0 points N/A Posted on -
qa-featured

Hello to everyone! I have a private business and I need all kinds of data that will be accessed easily everywhere for permits.

I thought a data server will be directly needed for the desk; there are many video seminars for this but unfortunately I don’t know about this, and I need help and advices.

I only use 3 to 4 external hard drives wherein you can manage 10 terabytes of hard drives and it requires performance.

Is this safe and are there any hardware failures to this?

For the best solution, I will wait any time for this kind of business and thank you.

SHARE
Best Answer by Molina Kevin
Answered By 80 points N/A #110725

Guidelines and advices about Data Server

qa-featured

Howdy Toby,

All I can suggest you is to go on the sites/links below which I provided so that you will be enlightened about your problem regarding data server. However, it requires patience and more understanding to be able to solve your issue. Here are the following threads/forums/article.:

  1. SQL Server performance
  2. Tutorial: SQL Server indexing tips to improve performance
  3. DBA Tips, Guidelines and Advice
  4. Specification recommendations and advice

I hope it might help. Have a great day and good luck.

Zorian

Answered By 0 points N/A #197495

Guidelines and advices about Data Server

qa-featured

Hello Toby White,

I have understood about your requirements. Now I am giving some introductory points about Data Server.

  • Data server is a client -server model which services to access Database from one computer to another computer.
  • It allows to index,query,report data on Database kept on server as usual.
  • With appropriate hardware the Data Servers can handle many tasks. 
  • Users may use different applications to access the information,but the server will operate the main data storage.
  • Data Servers depend on both server hardware used for networking and Server Operating system.

Therefore it is recommended that your network hard drives should be checked.Your router and modem should be updated .

Thank You

Shifflet Laurel 

Best Answer
Best Answer
Answered By 0 points N/A #197508

Guidelines and advices about Data Server

qa-featured

 

Hi,

These are some Guidelines and Tips about Data Server:

As a common and good practice, tables in your server should have a clustered index. Cluster index should be on a column that increases.

Indexes should be measured on columns that are often used in where, ORDER, BY, GROUP BY, TOP and DISTRICT class.

Do not use auto to add in adding indexes on a table because it is the right thing to do. Only add if you are sure that they will be the queries run against the table.

Create the indexes with a FILLFACTOR and a PAD_INDEX of 100 to be sure that there will be no wasted space.

Do not add indexes too much in your OLTP tables to minimize the overhead that occurs with indexes during data manipulation.

 

Related Questions