Viewing 11 posts - 1 through 11 (of 11 total)
You can rename a named instance to a new named instance, but you cant rename a named instance to default instance. For this you need to re install sql...
April 30, 2016 at 10:48 pm
Well I figured it out. This wait type occurs when lot of time is taken to harden the data at both the mirror server and principal server.This could be...
February 2, 2016 at 9:20 pm
How about the idea of partitioning the table on which the batch process is running
November 30, 2015 at 2:01 am
Grant,
This job is running from front end application and do not provide the provision of splitting the batch as instructed.
November 22, 2015 at 11:56 pm
Memory conjuction is happening when a job which was set to run daily to groom data older than 40 days .
Daily 2447639 records are getting groomed to an archive table...
November 21, 2015 at 3:59 am
Daily 2447639 records are getting groomed to an archive table located in the same database.
November 21, 2015 at 3:56 am
Memory conjuction is happening when a job which was set to run daily to groom data older than 40 days .
November 21, 2015 at 3:54 am
but the database instance contain 2 databases each with size 240 GB and 714 GB respectively. Dont you think that 80 percent memory is very less.
November 20, 2015 at 5:54 am
Since I have allocated 98 percent of memory for Sql server.Could it be the reason I am getting page_io_Latches
frequently
November 20, 2015 at 4:42 am
DB server consists of Inter Xeon processor(2 Processors) with 40 cores and a memory size of 64 GB. I have allocated 61 GB for sql server and the rest for...
November 20, 2015 at 4:30 am
Viewing 11 posts - 1 through 11 (of 11 total)