this database has 5 tables . all for saving log data. such as : addresses , searchs , sessions, referre site, errors ...

and biggest table of them is for saving...

Because there are bad query.

then I try to optimize them. (But I say this is hard work)

THX All

and dba-120883, About your reply.

In step 5 :

#5. Baseline the System

- Use tools like Performance Monitor, SQL Profiler, Active SPID Performance

1- Which Counters Do I control in performance monitor...

THX All

Feedbacks was very nice and wide

I should have read more carefully down the Answers

(specially about Hadoop and HiveSQL)

-----------------------------------------------------------

And now more details about your questions and ideas :

1- We offer...

Thank you GilaMonster

Can you tell me about the benefits of separate LOBs into another table?

(That I canconvince our developer team.)

Yes I mean Varchar(max) and nvarchar(max)

I read :

- If these fields be on one file group along with other fields, Delete or update on these fields can cause much defragment...

Thankyou very much

😀

is there any Ideas?

Hi

one of my top list is Latch_ex. (that you said It's maybe a problem)

I saw the waiting_tasks list and focus on Waittype. ((where waittype = latch_ex))

From this result :...

Thankyou

I try .UDL.

It is a good and fast way.

Hi

Thank you For your anwser.

No we dont have specific Performance Problem.

But we have an online bussiness and we should recognize problems and stay Performance in good state.

then I...

Thanks a lot

I will read about Latchs

and these are 15 top records :

...

Thank You For Your Guidness

this is the final result :

1- Check Connection With linked Server

Declare @LinkedServerName nvarchar(128)

Declare @retval int

Set @LinkedServerName='YourLinkedServerName'

begin try

...

Ohhhhhhhhhhhh !!!

SSC-Addicted !!! You are very PowerFull !!! :w00t:

Be successfull with your dear idera .

and thank you SSCommitted . 🙂

Hi again.

I know sqlserver sequrity and sql server registration . 😎

But unfortinataly I dont know "english" well. 😛 then I can't say me nessecey clearly .

I am...