simple select and creation of table taking too much time

Question

Hi I have so many databases in my sql server . currently iam working with 'DBtest ' database . if i execute simple select and create table on this DB it is taking too much time to run the query . suppose if i run the same queryies (both select and create table) in another database 'DBSample' and its running fast . Please help on this . Iam Unable to find the root cause of this.

Upendra Pratap Shahi · Answer

Your sql server query running slow,So there is no single reason for that. It could be due to following reasons: 1-Firstly check your SQl query execution time, if taking more time then optimize your query 2- If your table contains huge amount of data. You can add index in that table. 3- As you told that it is working fine with other DB. So you can increase storage space for DB. 4- Restart your server once 5- It might be memory problem of server 6- For testing purpose take backup current db and restore it again. If you find anything useful please accept my answer

Manas Mohapatra · Answer

Hi Tulasi, Your sql query running is slow. So there is no single reason for that. It could be due to following reasons: 1. If your table contains huge amount of data. You can add index in that table. 2. As you told that it is working fine with other DB. So you can increase storage space for DB. 3. Restart your server once 4. It might be memory problem of server 5. For testing purpose take backup current db and restore it again. Hope this will help you.