Viewing 15 posts - 331 through 345 (of 489 total)
What sort of information are you trying to capture? Have you looked at what the Default Trace gives you?
Leo
October 18, 2010 at 7:32 pm
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...
October 18, 2010 at 1:04 pm
amy26 (10/14/2010)
October 14, 2010 at 2:37 pm
pavan_srirangam (10/12/2010)
what is the schema of your SP its not sys. right.if you give the name with sys. spname it creates in system store proc.
I tested this and it wouldn't...
October 12, 2010 at 5:32 pm
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?...
October 12, 2010 at 3:05 pm
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...
October 12, 2010 at 2:21 pm
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,...
October 12, 2010 at 1:47 pm
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....
October 12, 2010 at 1:42 pm
Robert Hankin (9/23/2010)
Thanks for the helpful replies. If you bothered to check out the link i sent you may see that the author of this article is quite reputable...
Note...
September 23, 2010 at 2:08 pm
SequelSurfer (9/23/2010)
September 23, 2010 at 1:57 pm
Tara-1044200 (9/21/2010)
Views are very slower than tables while querying and also the execution plans are choosen differently, how can we trick views so that it performs like a table.
I'm sure...
September 21, 2010 at 3:42 pm
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...
September 20, 2010 at 10:32 pm
You really have given minimum infornation here. No join conditions, no where clauses or column names, no execution plans, no tables or table details. Sorry we can't help with some...
September 20, 2010 at 10:09 pm
I recommend you do a little reading in Books On Line, or Google this as there are a lot of examples on how to do this.
Cheers
Leo
September 15, 2010 at 8:33 pm
You don't need to worry about TempDB, it will grow as it needs to.
Carl's solution is also a good one if you have space on another disk, AND if this...
September 15, 2010 at 7:27 pm
Viewing 15 posts - 331 through 345 (of 489 total)