Guidelines and advices about Data Server

Asked By toby white 0 points N/A Posted on - 11/15/2011

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.

• Status: Open
• Question Views: 895
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Misc Networking

Best Answer by Molina Kevin

Go To Solution

Answered By Zorian Crust 80 points N/A #110725

Guidelines and advices about Data Server

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

About Zorian Crust

Questions
0

Answers
377

Best Answers
138

• Vote Up 0 Vote Down

• Posted on - 11/17/2011
• Question Category: Misc Networking

Answered By Shifflett Laurel 0 points N/A #197495

Guidelines and advices about Data Server

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 

About Shifflett Laurel

Questions
2

Answers
154

Best Answers
78

• Vote Up 0 Vote Down

• Posted on - 01/17/2013
• Question Category: Misc Networking

Best Answer

Best Answer

Answered By Molina Kevin 0 points N/A #197508

Guidelines and advices about Data Server

 

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.

 

About Molina Kevin

Questions
3

Answers
55

Best Answers
25

• Vote Up 0 Vote Down

• Posted on - 01/17/2013
• Question Category: Misc Networking