we have provisioned an Azure SQL MI GP with 8 cores and 512gb reserverd space.
I have created a test DB on it with both the data file and log file 100 mb each.
The DB compatibility level is 150 for 2019.
I have created 1 table :
CREATE TABLE [Test_Data] (
[Id] INT IDENTITY,
[Date] DATETIME DEFAULT GETDATE (),
[City] CHAR (25) DEFAULT 'Testing123',
[CityName] CHAR (25) DEFAULT 'Test Test1 Test2');
Then i insert data using the below for 1 k rows.
INSERT INTO Test_DATA DEFAULT VALUES ;
This insert takes close to 2 minutes to insert 1000 rows!!!! 2 mins for 1k rows is excessive , in my view.
Just for comparison on my laptop local sql instnace, the same query runs in 3 seconds.
I do not know what i am missing here .
Anyone , any thoughts please ?