overhead on the same database

Database snapshot fetch the data from the primary database,It will affect the performance of the database and overall performance of the server

Regards,

Syed Jahanzaib Bin Hassan

MCTS |...

1-Total physical or logical Processor ?

2-How much RAM allocated for the SQL Server in SQL Server ?

3-Operating System version and bit

4-SQL Server bit

5-Set MAX_WORKER_THREADS ?

6-Set Cost of Threahold ?

7-Set MAXDOP...

SELECT ServerProperty('LicenseType') as LicenseType, ServerProperty('NumLicenses') as ProcessorCount

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

you can define REMOTE QUERY TIME OUT and REMOTE LOGIN TIME OUT in SQL Server and also in SQL Server SSMS query analyzer

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA...

USE [MASTER]

GO

ALTER DATABASE REPORTSERVER SET OFFLINE WITH ROLLBACK IMMEDIATE;

GO

then restore it

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

CREATE TABLE DBINFO(ID INT IDENTITY(1,1) PRIMARY KEY

,DBNAME VARCHAR(200)

...

CREATE TABLE DBINFO(ID INT IDENTITY(1,1) PRIMARY KEY

,DBNAME VARCHAR(200)

...

1-Define MAX Memory parameter at least 24 GB

2-You have define Max Degree of Parallelism to 8,This will define as 2 because its depend on physical processor not on logical

3-Set MAX...

Every index should be rebuild or reorganize as per requirement,you can check the avg_frag_percentage in a dynamic management function

SELECT * FROM SYS.DM_DB_INDEX_PHYSICAL_STATS(DB_ID('DATABASE NAME'),,NULL,NULL,NULL,NULL);

When we Rebuild indexes when avg_frag_percentage...

If you are using SSMS query analyzer then this will not come you can manage this also in

SSMS->Tools->Option->Query Execution

Second thing is you can change query time out at the sql...

Try in the end of complete query

OPTION (MERGE JOIN)

or

OPTION(MAXDOP 2) --Its depend on the available Processors in the Server

create temp table for data you want to filter then join...

http://msdn.microsoft.com/en-us/library/ms191278(v=sql.90).aspx

bounce the sendmail

master..xp_stopmail

go

waitfor delay '0:00:05'

go

master..xp_startmail

go ...

whats the problem with you guys,I dont know why guy interrupting me,do your own work

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My...

whats the Version of SQL Server?

Is there any activity if some one changed the model and then changed backup to the previous one ?

Last Full backup is done successfully ?

Regards,

Syed...

That is a serious issue,did you check to bounce the agent service,

for the time being create an sp and include all jobs start script as

sp_start_job 'test1'

sp_start_job 'test2'

and so on......

and then...