What has to be proved...

When a parallel operation is created for SQL Query, there are multiple threads for a single query. Each query deals with a different set of the data (or rows). Due...

purushottam2 (1/28/2013)

---

CPU start consuming 100% in this case i run even a simple select command, it also take time..i have checked the query that are consuming most CPU time. I...

imani_technology (1/25/2013)

---

What is an easy way of doing this? I would like to avoid using replication if possible since this is only a temporary situation. Are there any...

Also verify blocked processes if any

SELECT

spid

,sp.STATUS

,loginame = SUBSTRING(loginame, 1, 12)

,hostname ...

try these queries

-- Find queries that take the most CPU overall

SELECT TOP 50

ObjectName = OBJECT_SCHEMA_NAME(qt.objectid,dbid) +...

its there http://technet.microsoft.com/en-us/library/ms175536(v=sql.105).aspx

this wil help you http://msdn.microsoft.com/en-us/library/ms190969(v=sql.105).aspx

purushottam2 (1/27/2013)

---

Above process creates new log file. But CPU utilization is 100 % now.

I have rebuild-ed all the indexes and updated stats of tables but still SQL is consuming 100%....

if exists (select 1 from sysobjects where name = 'getNotificateProduct')

DROP PROCEDURE [dbo].[getNotificateProduct]

GO

Create PROCEDURE [dbo].[getNotificateProduct]

(

)

begin

....

....

end

IS this...

first the records from both tables will be clubbed then UNION will distinct the records.

we also do data masking with below steps,

1) updating credit card information (randomly generated alpha-numeric words)

2) emails : adding some irrelevant prefix to profiler name plus changing the domains.

3) upodating...

see http://technet.microsoft.com/en-us/library/ms175536.aspx

why cant u use SSIS ? it provide great heterogenous environment

any reuirement ? or just a curiosity or interview question ?