Brandie Tarvin (11/23/2010)

---

Gangadhara MS (11/21/2010)

---

I have followed the same steps and found that some stored procedures having highest duration abnd IO/CPU.

But my developer saying i can't further tune with...

With the use of # tables like you have in these procedures, there are no indexes, so when you do the final SELECT, you will be doing a full table...

put the files back, start the DB and then delete properly

failing that, try to restore a DB over that one, same name, but moving the files, then delete properly.

Please make sure that understand what you are doing and have tested on a non-production system first.

Enabling AWE on the server:

http://support.microsoft.com/kb/283037

Enabling AWE on SQL:

http://support.microsoft.com/kb/274750

Now wheres my "disclaimer"..................................

At some of the companies that I worked at in the past (UK), they loved these things. For the server/network admins especially. These guys spent a lot of time in...

Setting up the maintenance jobs is great, but if the indexes are not appropriate, its wasted time (well not wasted, still needs to be done, but wasted for improving this...

Dont joke, that...

Well one argument (not seen in this thread yet) for the case of using NULL values is the introduction of SPARSE columns. This link discusses the space savings based on...

do you have sufficient space for the full backup file?

does the user running the backup (or service account) have the correct permissions to the UNC path? Running a exec xp_cmdshell...

only way I know of, to see what files are open, by who and the type of "lock".

more added to my original post 🙂

getoffmyfoot (11/11/2010)

---

Sounds like the cores are hyperthreaded.

Which brings up a tangent of mine - I have heard that it is "best practice" to disable hyperthreading on a windows server...

select * from fn_trace_getinfo(NULL)

--will return all the current running traces and some additional info (very similar to above)

maybe the wrong trace was stopped...

If you right-click on My Computer, go to...

saidapur_satish (11/11/2010)

---

Hi Ali,

1+TB data means not a jock..........

If you give the full backup means take too much time & also that time your server is...

The problem with having an automated system causing accidents, is who gets blamed when someone dies?? The programmer?? Who would want that job... Could imagine the lawsuit?