Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Server log error Expand / Collapse
Author
Message
Posted Monday, July 1, 2013 3:56 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:13 PM
Points: 39,866, Visits: 36,208
Did you read part 2?

You get the code for the procedures by going to the server and scripting the procedure out, you get the performance characteristics by running the procedure (on a non-production server)

p.s. Ignore the sqlagent procedures. They're system procedures, you can't change them and they shouldn't be a problem.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1468984
Posted Tuesday, July 2, 2013 2:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 11:04 PM
Points: 7, Visits: 43
If i unable to import the trace file into SQL Management Studio because one of the column "TextData" is too big compare with my column in table "TraceResult" , and i get the below error message.

Msg 8152, Level 16, State 10, Line 1
String or binary data would be truncated.
The statement has been terminated.

How to truncate and import it? Thanks

Regards,
Post #1469340
Posted Tuesday, July 2, 2013 3:01 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:13 PM
Points: 39,866, Visits: 36,208
CAST(TextData as Varchar(8000))

put that in the insert instead of just the column name.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1469354
Posted Tuesday, July 2, 2013 11:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 11:04 PM
Points: 7, Visits: 43
My top 3 procedure were this, do you think it is causing my server disc read/write high usage?
1. sp_executsql
2. proc_DeleteEventReceiver
3. msdb.dbo.sp_sqlagent_log_jobhistory

Regards,
Chungb
Post #1469850
Posted Wednesday, July 3, 2013 1:02 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:13 PM
Points: 39,866, Visits: 36,208
Since you've given no indication what the sp_executesql is executing or what proc_DeleteEventReceiver does, I have no idea. Why don't you investigate further?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1469862
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse