Viewing 15 posts - 76 through 90 (of 114 total)
Seems like the distribution is not cleaned up!
Check the retention days for each subscription. It should not be configured as "never expires"!
February 7, 2013 at 6:50 am
I hope it's 64Bit? What licences do "they" have :D?
February 7, 2013 at 6:36 am
Ever heard of things like for example : SQL Server 2008’s Management Data Warehouse ?
Nevertheless...there's especially a report for sp_Blitz...you can download it here!
February 7, 2013 at 6:15 am
Paul Randall
Most new systems today use NUMA, and so the buffer pool is split up and managed per NUMA node, with each NUMA node getting it’s own lazy writer thread,...
February 7, 2013 at 5:52 am
It's an average value. If you load big data amounts in the cache the value can be unsteady.
How about your indexes?
February 7, 2013 at 5:45 am
Exactly! To sum it up : Page Life Expectancy Extremely high is not a problem...it's a great!
February 7, 2013 at 5:41 am
Hm...I would say : If you got a lot of activity PLE is getting low(er) and if you got less activity the PLE is increasing, because the pages stay longer...
February 7, 2013 at 5:13 am
Why you think a long page life expactency is bad 😀 ?
This just means that your pages reside in memory for almost 13 days...wow...great value!
February 7, 2013 at 5:02 am
Try this:
The new user might not exist in the Users table. If that is the case, then you need to add/modify/delete something in the Reporting Server using that account...
February 7, 2013 at 2:52 am
Sorry...I was later than anthony...but I also didn't get your intention?
February 7, 2013 at 1:48 am
I don't think it hurts. I would say you don't need the entry without the port, but as long as it makes no troubles leave it like it was.
Better...
February 7, 2013 at 1:40 am
Why don't you just show us your list of SPNs?
The most important entries are:
setspn -A MSSQLSvc/<Fully qualified domain name of the server>:1433 domain\Account
setspn -A MSSQLSvc/<servername without domain>:1433 domain\Account
(Reporting Services)
setspn -A...
February 7, 2013 at 1:19 am
Thanks! This is what I allready suspected, but I was unsure if I'm right and if this would have a real effect...I'll post the results of the action ;-).
February 7, 2013 at 1:07 am
Have you got any of the lock escalation traceflags turned on?
Nope...
Are you using any locking hints?
Got snapshot isolation mode activated. The developers use NOLOCK AND ROWLOCK.
February 6, 2013 at 6:54 am
No, I don't think so...but how do i get an order respectively get rid of unused and poor indexes having only the "best" indexes left?
February 5, 2013 at 9:15 am
Viewing 15 posts - 76 through 90 (of 114 total)