Viewing 15 posts - 211 through 225 (of 619 total)
You dont need permissions to see the linked server but you need permissions on the destination.
So may your dev's have had the destination rights scrubed?
🙂
Adam Zacks-------------------------------------------Be Nice, Or Leave
July 29, 2010 at 8:49 am
How big is the database in question?
Is there a reason you have gone for L-shipping over mirror?
Is space/time an issue that prevents full backups each day?
Adam Zacks-------------------------------------------Be Nice, Or Leave
July 29, 2010 at 8:39 am
I have a similar issue.
I have a SQL 2005 Standard 32-bit server and our Idera DM reports that disk C:, E: (user db logs) and T: (temdb) are more or...
Adam Zacks-------------------------------------------Be Nice, Or Leave
July 19, 2010 at 10:16 am
It really depends what the selects do. If a select * from is used, chances are this is not your problem. But if they are running stored procs that create...
Adam Zacks-------------------------------------------Be Nice, Or Leave
July 19, 2010 at 4:15 am
Might be worth setting the 3GB switch anyway and the cap SQL max memory to 2.5GB to allow the OS 1.5GB but afford SQL as much as possible.
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 24, 2010 at 9:00 am
Schadenfreude-Mei (6/23/2010)
TWO FOR ENGLAND!!! 🙂
OH disallowed 🙁
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 23, 2010 at 9:05 am
TWO FOR ENGLAND!!! 🙂
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 23, 2010 at 9:04 am
D.Oc (6/23/2010)
Steve Jones - Editor (6/23/2010)
Is this soccer stuff over today?yes, 1st round is over
Much better then last Friday's sh*t!
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 23, 2010 at 9:03 am
GilaMonster (6/22/2010)
Can someone who knows their way around SQL memory have a look at this? http://www.sqlservercentral.com/Forums/Topic941169-360-1.aspx
I really wish i hadnt bothered 😉
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 23, 2010 at 3:45 am
Just wait. Be patient.
How large is your database? Transaction level? If you have a low usage small db, then SQL wont use the available memory until it needs it. Do...
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 23, 2010 at 3:32 am
Henrico Bekker (6/23/2010)
Schadenfreude-Mei (6/23/2010)
CirquedeSQLeil (6/22/2010)
GilaMonster (6/22/2010)
Steve Jones - Editor (6/22/2010)
Sorry, Gail, looks like SA is not moving on in the World Cup.🙁
What a surprise. Not.
At least we didn't lose...
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 23, 2010 at 1:50 am
You have to be patient. As SQL works and needs more, it will take more!
We have a cluster with 128GB and SQL max set to 96GB! However when the server...
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 23, 2010 at 1:46 am
OldMan,
I can second Gails and others comments, you should NOT set the min and max to the same. In your case you should set the max to 13500 (and to...
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 23, 2010 at 1:39 am
CirquedeSQLeil (6/22/2010)
GilaMonster (6/22/2010)
Steve Jones - Editor (6/22/2010)
Sorry, Gail, looks like SA is not moving on in the World Cup.🙁
What a surprise. Not.
At least we didn't lose every match we...
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 23, 2010 at 1:25 am
Looks about right.
Good luck, let us know if any issues.
A.
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 23, 2010 at 1:19 am
Viewing 15 posts - 211 through 225 (of 619 total)