Books Online is your friend. start with sp_trace_create, it links to the others. My profiler trace is text, cpu, duration, reads, writes, rowcount, starttime, databaseid, spid. That's...

Profiler will be better mechanism to capture the tsql that is causing DML on the table I think. See my earlier post.

That's quite interesting Dwain! I will have to set aside some time to break it down, and also modify it to work with the typical "UserID did something" scenarios...

Michael has good advice. I will amend it with a removal of the 90% fill factor recommendation. Many indexes in SQL Server can and should be 100% FF...

Try this:

SELECT

'create login [' + p.name + '] ' +

case when p.type in('U','G') then 'from windows ' else '' end +

'with '...

Ronnie Jones (1/23/2015)

---

Thank you guys for your reply!

So, you're saying that I shouldn't worry about the avg_fragmentation_in_percent number in my result set? I'm trying to setup routine maintenance and just...

The only reasonable explanation seems to be updates. Set up a tight trace to disk filtering on just the name of the table maybe to catch what is going...

I personally think 50K pages is a bit high, but agree with the principal that you should ignore small tables.

And you should definitely switch to Ola.hallengren.com's stuff for doing all...

girish.nehte-1109699 (1/23/2015)

---

Hi All,

I am having a limited knowledge in SQL. Let me explain my scenario in detail. I have to write a Stired Procedure with the following functionality.

Write a simple...

I concur. Plan change is good possibility. Another is blocking. Use sp_whoisactive to find that. That free tool can also show you a LOT about the...

Maybe it is just your efforts to anonymize the name, but you are missing a backslash in the file name? 'E:xxxxxxxx.trn'

Outside of that try running a profiler...

ericb1 (1/22/2015)

---

Ok, thanks, is there a way to use windows (2012r2) to do it with a command-line? Just trying to automate it without having to install extra software on...

Hire a good consultant to do the performance review for you and learn from them and their findings document.

Failing that, there are a baJILLION things you could pursue....

pkapas (1/22/2015)

---

Haha, well that's a + for Microsoft then. A good product starts with making sure it can adapt to even inexperienced users. I'm planning on getting better with SQL...

Windows has built-in ability to compress files. 7-z or others may have command line ability too.

You could stop using Comm Vault. Also, are you 100% certain it cannot...