August 30, 2010 at 8:51 am
I have two big SQL Script files, one contains SQL "create table" statements for creating around 900 tables and another file contains SQL "create view" statement for creating views for above created tables. Both include GRANT statements for providing permissions to a certain "Application role" for each created table and view. The SQL script files are executed from SQL server by the stored procedure using the SQLCMD.
The tables and views are created successfully, but the whole process affects the performance of SQL server. Looking at the performance monitor the values for Physical Disk: "Avg. Disk Read Queue length" and "%Disk Read Time" are very high than expected.
1. Is there anything I can do to reduce those values or enhance performance in general?
2. On the SQL Scripts there is no "Go Statement", so the whole SQL Script is like one large transaction. Can it be any help by placing “GO Statement” after each CREATE statement? I will try to do this later but I am asking if there is any body experienced this before.
I will appreciate any input. Thanks
August 31, 2010 at 1:29 am
Sorry, I added this topic on the wrong section, it is for SQL server 2008 and not SQL Server 7. So, I have moved the topic to SQL Server 2008
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply