Hi there

It really comes down to the architecture of the application, from there, you have a better opportunity to scale the application and ask questions from the group on specific...

I read an article (cant remember where though!) about partitioned views. Apparently queries are still executed serially from 1 server to the next and not in parallel (which you...

Hi all

Thanks for the input, Ive picked up a few things already, is there a way of dumping the buffer cache contents? (probably a trace number).

Cheers

Chris

Hi

I use SQL*Probe and have also used Spotlight. Both are excellent products and well worth looking at. In the end you need to clearly define the type of...

ill give it a look 🙂

Steve - yep, no problem there, but when I search a non-clustered index and get the the leaf node, what does it point to? to start of the page in...

Hi there

I just read a short paragraph from a performance tuning book by England. He basically says what you stated and I can see your point now. Basically,...

.Net excites me about IT and MS in general, especially where its going to take SQL Server. I enjoy playing around with rarely used features, namely clustering and replication....

Dont believe what profiler tells you, full stop! 🙂

Sorry, but I have never come accross any figures in profilers duration column that is even half close to the truth. ...

Hi

I believe you wont have any compatibility issues for anything like that, but you may experience CPU contention. As an example, we use COM+ for all our business logic,...

thanks guys, i ran some tests with full-text and the performance has improved 200%, but as we are going live in 2 weeks we will hold off for the time...

Hi

Not quite (others please correct me!). The cluster index IS a b*tree index as the word "index" defines, but it also defines the storage of data in the table,...

Hi all

Found it. In the NT event logs it told me that perf counter dll's have been removed. Oh well, there goes a bulk of my perf tuning...

nope - use query analyser or isql/osql for command line.

try and test on your local machine first 🙂

here are some examples for some of my databases...

DB1

data = 57Mb

index = 0.81Mb

backup file size avg = 48Mb

winzip compressed = 8Mb

DB2

data = 1.7Gb

index = 158Mb

backup file size avg = 916Mb

winzip...