Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Overview IV - DBA's Morning Review


SQL Overview IV - DBA's Morning Review

Author
Message
ephremm
ephremm
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 145
Thanks for quick response,

Please let me know when successful with the all jobs monitoring...

Thank you!
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36066 Visits: 18736
The download has been updated to correct a few bugs, courtesy of Mr. Bird.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
wyfccc
wyfccc
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 147
Mr. Bird^_^
I learned a lot from your article. thanks a lot.
If it is allowed to use sp_cmdshell, we can use findstr, that is a windows command, to find the error message we cared in SQL ERRORLOG. It is more efficient.
eletuw
eletuw
SSC-Enthusiastic
SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)

Group: General Forum Members
Points: 144 Visits: 282
Instead of having the log parser on each server, you may have each server configured so sql server error messages are forwarded to a single server where the log parser tool is executed.



Luke C
Luke C
SSC Veteran
SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)

Group: General Forum Members
Points: 259 Visits: 1144
I would just like to say THANK YOU. Not having to look at each server for failed jobs is a huge time saver.

Luke C
MCSE: Data Platform, MCP, MCTS, MCITP - Database Administrator & Database Developer
clmitchell
clmitchell
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 79
Hi David,

I'm receiving the following error when running the checkout package on some of our SQL Server 2000 instances:

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MultiServer" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

I compared server configuration parameters against other 2000 SQL Servers that executed the checkout successfully but I didn't find anything different. Any ideas?

Thank you,
Chris
clmitchell
clmitchell
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 79
Never mind the post above, I had to enable named pipes in the SQL Server Configuration Manager.

Also, I noticed that I get a duplicate key error with named server instances when running the report of missing database backups. I made the following tweak in bold to the first step of the SQL Agent job to correct this :

INSERT INTO [rep].[Database_List]
([Server],DatabaseName,Usage)
SELECT [Database_Status].[Server]
,[Database_Status].[DatabaseName]
,isNULL([SSIS_ServerList].[Usage],'NA')
FROM [Database_Status] INNER JOIN [SSIS_ServerList]
ON [SSIS_ServerList].[Server] = [Database_Status].[Server]

Where NOT EXISTS (select * from [rep].[Database_List]
WHERE [Database_List].[Server] = [Database_Status].[Server]
AND [Database_List].[DatabaseName] = [Database_Status].[DatabaseName]
)
David Bird
David Bird
SSC Veteran
SSC Veteran (271 reputation)SSC Veteran (271 reputation)SSC Veteran (271 reputation)SSC Veteran (271 reputation)SSC Veteran (271 reputation)SSC Veteran (271 reputation)SSC Veteran (271 reputation)SSC Veteran (271 reputation)

Group: General Forum Members
Points: 271 Visits: 1186
Thanks for posting solutions to the problems you experienced with the package.

David Bird

My PC Quick Reference Guide
Jason Crider
Jason Crider
SSC Veteran
SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)

Group: General Forum Members
Points: 285 Visits: 2229
Super series of articles. This has helped me streamline monitoring and also learn SSIS more effectively.

Many thanks for taking the time to contribute.

I've found a few things that might be worth looking at:
1. The list of Report Jobs shows "DBA-SQL Overview - Report Large Log Files" but the script to create the job has "@job_name=N'DBA-SQL Overview - Report Large Log File'"

2. DBA-SQL Overview - Report Job Failures
"SELECT @From=@@SERVERNAME + ''@choosebroadspire.com''"
You actually have this in other places as well, is it just something that wasn't cleaned up?
EDIT: I believe I know why this is here now.

"@output_file_name=N'I:\Output\Job\DBA-SQL Overview - Report Job Failures.txt', "
May need to be changed to an appropriate drive on the Host Server.

MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
Harold Buckner
Harold Buckner
Old Hand
Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)

Group: General Forum Members
Points: 317 Visits: 420
Hey David., I know this is an old thread but I really liked your approach and have developed on top of yours. I had a question about drive spae and low drive space and how you would handle my issues.

We have a SQL cluster with 12 instances of SQL. Each assigned their own Logical drive and one mount point. So for instance sql1 it would be assigned drive H and the mount point would be H:\LOGS. Instance SQL2 would have drive J: and Mount point J:\LOGS

Your drive space scripts, has every drive on the cluster node under each instance server name. So for instnce...if there are 5 sql instances on each node, each instance would have 5 drives under each one. None of the mount points are listed.

Are there any views or tables that shows what drive letters each SQL instance can see or uses? Is there any new methods that replaces the (sp_OAMethod @fso,'GetDrive', @odrive OUT) si that we can get drive space from mount points?


Hope your stilll around and monitor this.. Thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search