premkuttan.lakshmanan (10/19/2010)

---

My tempdb raised to 25 GB since i was executing a query but even after execution of the query the size of tempdb remains same can anyone help...

As per the clustering key width, it would be 17 bytes instead of 8, it's not that bad (is it?).

..

Also, the table is partitioned (6 partitions) on Receiving_Number, but just...

Unless the user suspects you are tracing them and runs:

SELECT * FROM :: fn_trace_getinfo(0)

and then runs:

SELECT * FROM :: fn_trace_getfilterinfo (trace_id),

They won't see the trace.

You could block their execute rights...

What sort of information are you trying to capture? Have you looked at what the Default Trace gives you?

Leo

Based on the little information provided I can't see that changing the indexes would help. You really need to see what queries are performing badly and then ID why those...

amy26 (10/14/2010)

---

so with the sp_create_trace ... after reading a little... its basically a programmatic way to tell sql server to start a profiler trace? And I can stop it...

I tested this and it wouldn't...

I've tested this on my SQL 2005 server and can't get it to save an object in System Stored procs.

Are you sure they are actually defined as system stored procs?...

A few comments:

1) Post the execution plans from the 2 machines so they can be checked. This isn't only to see if they could be improved, but it's not unusual...

Sorry but the sp_start_job stored proc only accepts a single job name.

try:

EXEC dbo.sp_start_job N'Weekly Sales Data Backup' ;

go

EXEC dbo.sp_start_job N'Next Database Data Backup' ;

go

Alternately you could just schedule the jobs,...

When the script is run from the agent it is being run in the context of the account that the SQL Server Agent runs under. In your case NT AUTHORITY\SYSTEM....

Note...

SequelSurfer (9/23/2010)

---

It turns out the parallelism (in my case at least) was being caused by an unnecessary ORDER BY. Funny thing is, I don't remember it being a new change,...

I'm sure...

To have more than 2 nodes in a SQL Cluster you need SQL Server Enterprise Edition.

You can definitly have it on it's own node. We have a client that has...