Splitting Your Database Files by Using SQL Server Management Studio

SQL Server ships with a fantastic graphical user interface: you might say the iPhone of database administration. It is called SQL Server Management Studio. SQL Server Management Studio gives the part-time SQL Server database administrator who is running Windchill a big advantage: an easy-to-use tool that can connect to any SQL Server database (SQL Azure, SQL Server Express, or SQL Server). You can use SQL Server Management Studio to configure the database, change the schema, and read and modify data. Learning the basics of this tool can save you a lot of time, i.e., improve your personal performance.

This post will show you how to split your database files for better performance by using SQL Server Management Studio. In my April 20 post, I discussed the need for dividing the data in your database across multiple RAID 1 arrays to reduce the drive wait time for I/O reading and writing.
Introduction to SQL Server Management Studio

I am going to be writing about SQL Server Management Studio in the future. But for now, here are some good tutorials about how to start it and how to connect to your database:

· Starting SQL Server Management Studio

· Connecting with Registered Servers and Object Explorer

After you have Object Explorer connected to your instance of SQL Server, you can expand the SQL Server instance node and see a tree view of all the database nodes on that instance.
Data File Configuration

The data file configuration is under the properties of the individual database. Let practice adding another data file to the primary filegroup in the AdventureWorks database. To do this, just follow these steps:

1. In Object Explorer, expand the SQL Server instance node.

2. Find the database that you want to configure.

3. Right-click the node, and then click Properties. The Database Properties Dialog box will open.

Read more: PTC Windchill on SQL Server

Posted via email from jasper22's posterous