Viewing 15 posts - 286 through 300 (of 2,640 total)
I'm not sure that lock pages is actually a SQL specific property. I always think of this as being more of an o/s property in as much as you can...
May 9, 2011 at 5:43 am
so what you are asking is for someone to provide you with a set of basic database/server checks in a word document for you to produce reports on something you...
May 9, 2011 at 5:31 am
I don't have that combination of databases, don't use express, but one mthod to move a database across editions/versions is to use snapshot replication. I figure that the database...
May 9, 2011 at 5:15 am
no worries - if you want more info drop me an email through the blog or my website
January 12, 2011 at 4:19 pm
I have a 10Gb lun. I read somewhere it was recommened to use a dedicated lun - failing that did I really want it on a data/log or backup lun?
January 12, 2011 at 4:16 pm
I do make use of partitioning despite the restrictions, there's a link on my blog to a a large document i produced for a presentation I did which talked...
January 12, 2011 at 4:11 pm
yes - been there done it. I cover some of the basic concepts in this pdf of a presentation I did
January 11, 2011 at 1:45 pm
I can only tell you that I cluster MSDTC, it's best to allocate a dedicated lun to it ( doesn't have to be big ) other than that can't help...
January 11, 2011 at 1:41 pm
ah well if it's application then it's processes/code that you need to change - if it's system stuff then you need to find a quiet time. I support real 7...
January 11, 2011 at 1:39 pm
yeah I think I'd have done a rebuild by now, once you spend more than a couple of days it's better to bite the bullit and rebuild. You also get...
January 11, 2011 at 1:35 pm
well it's a bit of a guess but I'd say the combination of VMware and 2 cores just doesn't provide enough workers.
There's some things you could try: disable parallelism, enable...
January 6, 2011 at 3:41 pm
not quite sure what you're asking but yes "system" processes can evoke deadlocks - that's why you have to configure your server to avoid such issues. Index rebuilds for instance...
January 6, 2011 at 3:24 pm
I haven't had to do what you have but i did have problems registering a spn.
I am a domain admin so i added the sql server service account to the...
January 6, 2011 at 3:20 pm
It'll be making best guesses I suppose - there's always going to be a variation every time I guess.
January 6, 2011 at 3:16 pm
was a time you had to update sysjobs to avoid this, but sql 2008 doesn't require this. I always make the owner of the jobs sa though - make sure...
January 6, 2011 at 5:08 am
Viewing 15 posts - 286 through 300 (of 2,640 total)