Viewing 15 posts - 16 through 30 (of 66 total)
How critical your setup is? What application are you using?
AFAIK logshipping is not a good solution here. Go for mirroring where application would connect to the new principal server if...
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 9, 2009 at 2:04 am
Any headsup!!
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 9, 2009 at 1:57 am
So the status is sleeping when the process is waiting for resources for long... Is there any time period which switch this from running to sleeping status, David.
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 8, 2009 at 10:37 am
Many thanks to Phil Melling and David. Great learning for me...
Ciao
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 8, 2009 at 10:33 am
True SA. My straight question to everyone here. Does defrag also affect index defrag. This is not an an easy question and this depends on how defrag affects data pages....
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 8, 2009 at 9:26 am
This can help
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 8, 2009 at 9:04 am
Do we really require rebuilding of indexes after defrag. Yes we should shut the m\c down if possible.
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 8, 2009 at 8:52 am
Oh Abhijit.
I am sure that you would be using sp_creatediagram sp in your application. can you revoke execute permission on this from those users? This would help.
REVOKE EXECUTE ON OBJECT::DatabaseName.SPName
FROM...
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 8, 2009 at 8:46 am
One great confusion guys. Take a scenario where we have 8 GB memory. My OS is 32 bit and sql server application is also 32 bit.
Sql server application will...
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 8, 2009 at 5:51 am
Good. Read my post again pls. 32 bit => 4 GB. This can't address more than 4 GB.
Yes 64 GB can address 4 GB. Did you get my point. This...
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 7, 2009 at 8:45 am
David,
The catch is that 32 bit sql server would be able to address 4 GB at the max irrespective of whatever 13 or 14 GB we allot to this. Then...
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 7, 2009 at 8:24 am
David,
The catch is that 32 bit sql server would be able to address 4 GB at the max irrespective of whatever 13 or 14 GB we allot to this. Then...
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 7, 2009 at 8:21 am
SA is correct. Backups should be maintained at some disaster recovery site.
Anyway you can click on add then on radio tab click on file name and then browse to...
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 7, 2009 at 8:15 am
Hello David,
Is my understanding correct for the first para?
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 7, 2009 at 7:50 am
David,
Do you mean irrespective of how much RAM we have available, if we turn /3GB on then only 1 GB would be available for OS?
I have two questions in my...
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 7, 2009 at 7:29 am
Viewing 15 posts - 16 through 30 (of 66 total)