Viewing 15 posts - 1,126 through 1,140 (of 4,272 total)
You are very welcome, let us know how it goes.
CEWII
July 29, 2011 at 9:37 am
Right, but the location must already exist to put the file there. Which is why I follow the process I detailed above.
So, master, model, and tempdb.
CEWII
July 29, 2011 at 9:35 am
My understanding is that that is true, I am also 99% sure that you will also be required to set Lock Pages In Memory for the Login that you run...
July 28, 2011 at 3:45 pm
Do you have the PAE or 3GB option set in the startup for the OS? If not then you won't use more than 1.7GB for SQL no matter how...
July 28, 2011 at 1:08 pm
Its likely having trouble finding either the log for master or one of the tempdb files. I believe that you can start a SQL server with as little as...
July 28, 2011 at 1:05 pm
You just told me something that triggered a thought.. you are saying each instance uses about 1.75GB of memory. Is this a 32 or 64-bit server and are...
July 28, 2011 at 10:44 am
So it is inconsistent.. Super.. Hate that.. Hm, how is your memory utilization? Memory pressure?
CEWII
July 27, 2011 at 3:25 pm
opc.three (7/27/2011)
Even if clients were using different server names that...
July 27, 2011 at 11:41 am
I used to do this with prod -> qa/dev machines, but I always built the qa/dev machines with the exact same sql version and drive paths as the production unit...
July 27, 2011 at 10:59 am
Grasping at straws...
But is the provider configured to be in or out of process on each instance? Also does it EVER work or does this happen intermittently?
CEWII
July 27, 2011 at 10:44 am
Hold up..
If you mean, how am I connecting, for the oSQL test here's my connection string:
osql -S dbserver\dbinstance -U sql_user -P xxxxxxxxx
Given your config I really can't see that working....
July 27, 2011 at 10:40 am
Koen Verbeeck (7/27/2011)
darkfour (7/27/2011)
Question: Do you have certifications
Comment: This is rather disappointing point for me. Qualifications generally are welcome but unfortunately many people simply cheat. Companies run courses and then...
July 27, 2011 at 10:00 am
Jobs are separate entities, the run on whatever schedule you have setup and if one fails the others keep going.
CEWII
July 26, 2011 at 8:25 am
First, for future reference please start a new thread for your own questions instead of hijacking an existing one.
The number you reference is the default value which effectively means "use...
July 26, 2011 at 8:23 am
It will use as much as you allow it IF it needs to. Out of the box the max memory setting is "everything", however, even then if the workload...
July 25, 2011 at 11:07 am
Viewing 15 posts - 1,126 through 1,140 (of 4,272 total)