Viewing 15 posts - 3,721 through 3,735 (of 5,843 total)
RedGate has recently announced V2 of their Monitor product. It does quite nicely I think.
If you want something more high-end I highly recommend SQL Sentry's Performance Advisor product.
January 7, 2011 at 7:38 am
1) the cause is often due to bugs, especially in drivers. windows 2003 had a large file copy bug that did this and HP's ILO stuff likewise. I had a...
January 7, 2011 at 7:36 am
mcroce (1/6/2011)
Ratio of Batch requests to Page Lookups should not be much greater than 100. If it is, it indicates too much logical I/O because of bad query plans
which are...
January 7, 2011 at 7:35 am
Good luck with the testing. Don't forget to size tempdb appropriately and not wait for autogrowths to size it for you.
January 7, 2011 at 7:33 am
Can you say which function call it was in the where clause and how you fixed it? Not sure I see it in your OP statement - or was...
January 7, 2011 at 7:32 am
Aditya-313343 (1/4/2011)
Breif: Can some one plase suggest me how to lock a table when inserting data into it by a process,to make sure other process which might run simultaneously...
January 6, 2011 at 8:20 am
Thanks for the props Gail! Look forward to seeing you again at the MVP Summit in 7 weeks!
January 6, 2011 at 8:18 am
I didn't see anyone mention it yet, but RedGate has recently announced V2 of their Monitor product. It does quite nicely I think.
If you want something more high-end I...
January 6, 2011 at 8:15 am
As someone else said - installing SQL Server to a non-root drive still puts a LOT of crap in the root!! I would do one of two things: ...
January 5, 2011 at 7:02 am
You have unfortunately chosen a horrible storage construct for your data known as Entity Attribute Value Pairs. Your use of it is absolutely unscalable and there is essentially nothing...
January 5, 2011 at 6:57 am
6 out of 8 is likely a tad too high, but not enough to cause you problems like you are seeing. Only SQL - so you are not using...
January 5, 2011 at 6:39 am
1) WHY do you think you want to partition this table??
2) Partitioning is a VERY advanced topic that you have essentially no chance of doing completely optimally the first time...
January 4, 2011 at 3:48 pm
ola.hallengren.com
that one is best IMHO because it offers up much more than just index maintenance stuff.
January 4, 2011 at 3:45 pm
In my experience (which is a LOT when it comes to sql server perf analysis and tuning) the vast majority of async network io waits are caused by slow client...
January 4, 2011 at 3:44 pm
calvo (1/4/2011)
I have an admin database that I use to track performance and other items...
January 4, 2011 at 3:39 pm
Viewing 15 posts - 3,721 through 3,735 (of 5,843 total)