Viewing 15 posts - 1 through 15 (of 34 total)
Mbrood,
Im facing similar kind of issue where a job is running for a very long time and when checked the process it shows that the waittype for the...
May 23, 2008 at 11:09 am
When the db's are detached & attached to SQL2K5 the compatability level for the db must be changed to 90. If not some of the new features will...
January 28, 2008 at 1:09 am
as you said if the script is taken for a user db and run it should not replace other logins and db access.
Well try one thing use the...
January 17, 2008 at 4:07 am
Hearty Congratulations STEVE....Good show....
Its delayed but you really deserve it. Keep going in providing more such solutions.
Cheers
Murali.a
January 6, 2008 at 6:36 am
Thank u all folks for your responses.
There were some active transaction that was running for a very long time could be due to that.
Murali.a
December 4, 2007 at 5:31 am
yes but it would be a very lesser amount, not that much to say an error like "Log is full. Backup the tran. log".
How to check this huge growth...
December 3, 2007 at 4:25 am
Jeff that's great man...I like the way you thought about ....
keep posting such stuffs man.....;)
Murali.a
November 29, 2007 at 5:44 am
Initially we thought of doing that but the server owner has not shown interest to continue with that...but is there a way to identify whether the mem-to-leave is fragmented or...
November 26, 2007 at 10:47 pm
The same had the case with me and i have applied the fix to get use of my memory. I had fixed memory on sql to use 3gb and previously...
November 23, 2007 at 2:28 am
Ok. I have checked it before but that's no the case. It does use 4096 and the application uses the same size when checking with a trace.
I also doubt that...
November 21, 2007 at 10:54 pm
Will check that..
But by disabling these setting will the warnings go.
November 20, 2007 at 6:45 am
adding to the above one.
Initially after enablilng awe and /3gb switches sql server was not taking beyond 2gb of memory, then we have applied a hotfixkb899761 and...
October 29, 2007 at 12:27 am
folks, thanks for all your response.
The above said server is a cluster one (active\Passive) Let me know if the above said can be tested out or is...
October 29, 2007 at 12:13 am
anything beyod 2gb would required awe to be enabled right?
September 27, 2007 at 5:21 am
Still no hint in resolving the above error. Let me know if any other updates about this.
Murali.a
September 27, 2007 at 1:04 am
Viewing 15 posts - 1 through 15 (of 34 total)