Viewing 15 posts - 1 through 15 (of 1,154 total)
elhelalaoui (5/12/2014)
Do you mean that I must create 2 step in one JOB ?1st Step witch contains that command.
Second step with the SSIS package.
Thanks.
No just one step. You already have...
May 13, 2014 at 8:10 am
elhelalaoui (5/5/2014)
Sorry for the delay, I had personal difficulties so I could'nt do this test.
I've just launched that query and it appears that it goes well (Message : Job 'Test'...
May 9, 2014 at 1:01 pm
Jeff, it's a statement made in general as we didn't have the specifics. It's only a suggestion to consider. We can make it a long academic discussion if needed.
--
SQLBuddy
April 15, 2014 at 9:14 am
New Born DBA (4/15/2014)
sqlbuddy123 (4/14/2014)
How many DBs are you going to add per new customer ? And why do you want to add 2 instances ?
We are adding 2 instances...
April 15, 2014 at 8:47 am
GilaMonster (4/15/2014)
sqlbuddy123 (4/14/2014)
AWE needs LPIM to be enabled but not vice versa (Ex: 64-bit systems).
Not true. Once Locked Pages is enabled, memory allocations can be done via the AWE...
April 15, 2014 at 8:37 am
GilaMonster (4/14/2014)
sqlbuddy123 (4/14/2014)
My question was Why is this dependency and how can this be justified ?
When the Windows Engineers were working initially on AWE for 32-bit processes they implemented it...
April 14, 2014 at 8:04 pm
As your SAN LUNS span the same physical drives, it won't much useful in separating the files out. But nothing wrong in separating them as it leads to ease of...
April 14, 2014 at 3:52 pm
k.satya2 (4/14/2014)
i have some input's in mind.
1) i have to apply...
April 14, 2014 at 3:42 pm
Check if there is any resource contention (CPU, Memory, Ntk ..) \ blocking on the server that's causing this ..
--
SQLBuddy
April 14, 2014 at 3:07 pm
Counters look good. Did you experience any memory pressure or had any memory related error messages during the time of that alert ?
--
SQLBuddy
April 14, 2014 at 3:01 pm
How many DBs are you going to add per new customer ? And why do you want to add 2 instances ?
You can ask your VM admin to capture the...
April 14, 2014 at 2:56 pm
My question was Why is this dependency and how can this be justified ?
GilaMonster (4/14/2014) Only applications with the locked pages in memory privilege have permission to call the AllocPhysicalMemory...
April 14, 2014 at 12:36 pm
GilaMonster (4/14/2014)
sqlbuddy123 (4/14/2014)
It's bit weird bcs they both do different functions and still MS interlinks them.
No, they don't do different things. MS interlinks them because they're actually the same thing...
April 14, 2014 at 12:12 pm
GilaMonster (4/14/2014)
sqlbuddy123 (4/14/2014)
I'm not sure why MS interlinked both of these settings.
Because they're very tightly linked.
AWE memory is allocated using the AllocPhysicalMemory API call (I'll get you the actual API...
April 14, 2014 at 12:03 pm
mlwiller2 (4/14/2014)
April 14, 2014 at 11:50 am
Viewing 15 posts - 1 through 15 (of 1,154 total)