2
2
25202015-01-08 23:28:35
SQL
2520, 2015-01-08 23:28:35

Very slow MS SQL with VS 2013, what is the reason?

When creating a database from scratch, query execution is slow - about 1 minute to create a table with 2 columns. The disk is not loaded. What could be the reason?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
S
Sergey Nalomenko, 2015-01-08
@nalomenko

bill-gates.jpg?w=500

S
Sumor, 2015-01-09
@Sumor

A long connection to MSSQL may be due to checking the certificates of the client computer.
In Internet Explorer, on the server with MSSQL, you need to disable checking for revoked certificates.

Internet Explorer -> "Internet Options" -> Advanced".
Disable:
Check for publisher's certificate revocation
Check for server certificate revocation

R
RomanAkaMagician, 2015-01-09
@RomanAkaMagician

If vs2013 and mssql are on the same machine, then try to explicitly use 127.0.0.1 instead of localhost in the connection settings - sometimes it helps.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question