Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Analyzing database schema takes hours

Using a new SQL2005 database project in VS2010. I did import objects and settings, and built the project. It seems to be stuck at 'Analyzing database schema. Your database projects will be ready after 3267 operations are completed'.

This seems to take hours. Is there any way to speed this up?

I read somewhere that this may happen if my .dbmdl file is too big, but it's just 2.6MB.

like image 280
xt_20 Avatar asked Mar 16 '12 08:03

xt_20


People also ask

What are the 3 types of database schema?

Schema is of three types: Logical Schema, Physical Schema and view Schema.

What is a schema query?

In a SQL database, a schema is a list of logical structures of data. A database user owns the schema, which has the same name as the database manager. As of SQL Server 2005, a schema is an individual entity (container of objects) distinct from the user who constructs the object.


1 Answers

  1. Go to Project Settings
  2. click on the Database Settings button
  3. Under the Operational tab

    3.1 uncheck Auto create statictics and

    3.2 Uncheck Auto update statistics checkbox.

This will reduce your numbers of operations by about 90% and the analysis should finish instantly.

like image 117
Rushui Guan Avatar answered Sep 18 '22 18:09

Rushui Guan