JustANumber (4/14/2010)

---

Thanks for the tip on that white paper. I had browsed MSDN looking for help but didn't come across that document. After a quick look through the...

Microsoft has fantastic documentation on the particular, please check http://msdn.microsoft.com/en-us/library/aa964137(SQL.90).aspx

gregory.anderson (4/14/2010)

---

And these stats prove your point...

--With unique index on primary key, 6706 permits created in 582 seconds, which equals 11.5/sec

--With no index on the primary key, 2520 permits created...

gregory.anderson (4/14/2010)

---

Ok, I modified the stored proc to add the @Today = GetDate() right before it does each insert into PWDPermit so I could gather some real timings, right now,...

Please let us know how it goes.

gregory.anderson (4/14/2010)

---

PaulB-TheOneAndOnly (4/14/2010)

---

gregory.anderson (4/14/2010)

---

After trying Elliot's suggesting about displaying the actual execution plan, it appears as though the most time consuming/resource intensive portions of the proc are in "Clustered Index...

Are...

I assume what you want is what you have in your view, is that correct?

If that's the case use COldCoffee solution but in FROM clause type in your view name...

First - remember that members of sysadmin and serveradmin fixed servers have shutdown privileges then check who are the members.

Second - check if anybody has the specific privilege granted, you...

vijay82 (4/13/2010)

---

i am new to DBA? Can any one heip me how tickets as generated and on which base they are going to assigen to DBA persons.what is the IM(incident...

glad to help 😉

Here is...

First thing first... find out where those 24 hours are spent.

Such a process should have two very different steps...

1) Mainframe to SQL Server staging table.

2) SQL Server staging to final...

I agree with Elliot, this is highly unusual in...

Check the full path.

Log into the server using SQL Server service account and check if you can "see" the dump file in the location you are telling SQL Server to...