Viewing 8 posts - 1 through 8 (of 8 total)
Hi Jeffrey,
I am not getting this facility in SSMS. I think it is possible only through tsql script .
December 20, 2021 at 2:25 pm
Before terminating sql services I got below error message in sqlserver error logs:
The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your...
April 2, 2014 at 12:57 am
This job runs for a long time (more than 3 hrs) but normally it takes few seconds to complete.
Now if i stop and start the job it takes only few...
February 5, 2014 at 2:46 am
Hi,
I have verified fill factor which didn't get changed after rebuilding indexes..
and normal update query which used to take eralier 0 sec but now it is taking 6-7 sec
March 22, 2013 at 8:41 am
Thanks for this information.
Main issue is slowness and when ever slowness occurs i see temp block in databases ,so when i kill the culprit blocker the issue resolved.I was able...
November 12, 2011 at 1:01 pm
I am not sure whether there in any memory issue but i can see SQL only using 13.8 GB memory constantly but i have configured max memory 20GB.
I was suggested...
November 12, 2011 at 12:39 pm
Viewing 8 posts - 1 through 8 (of 8 total)