Click here to Skip to main content
14,543,344 members
   

Database

 
QuestionApplication stopped working after backup and restoring the Database with another name Pin
indian14326-Mar-18 8:55
Memberindian14326-Mar-18 8:55 
AnswerRe: Application stopped working after backup and restoring the Database with another name Pin
Richard Deeming26-Mar-18 10:00
mveRichard Deeming26-Mar-18 10:00 
GeneralRe: Application stopped working after backup and restoring the Database with another name Pin
indian14327-Mar-18 6:10
Memberindian14327-Mar-18 6:10 
QuestionSQL server job execution time Pin
VK1922-Mar-18 7:47
MemberVK1922-Mar-18 7:47 
AnswerRe: SQL server job execution time Pin
Victor Nijegorodov22-Mar-18 8:40
MemberVictor Nijegorodov22-Mar-18 8:40 
GeneralRe: SQL server job execution time Pin
VK1922-Mar-18 9:11
MemberVK1922-Mar-18 9:11 
GeneralRe: SQL server job execution time Pin
Victor Nijegorodov22-Mar-18 9:45
MemberVictor Nijegorodov22-Mar-18 9:45 
AnswerRe: SQL server job execution time Pin
David Mujica26-Mar-18 5:55
MemberDavid Mujica26-Mar-18 5:55 
What is the nature of this job? Does it create records ? Or read the data? How big is this database ? How are many disks are installed on the server? How are they being used by the database engine? Are the Operating System and database files on different disks?
On the database server from a command prompt type "perfmon" to bring up the Performance Monitoring Utility. You want to add a counter for Logical disk / Avg Disk Queue Length (All disks) Look at the graph while the job is running, if you see high activity on one disk and low activity on another disk, you may want to consider moving some DB files around.

Here are a couple of things to consider:
1) Count the number of rows in the tables involved. Check these values daily, weekly, monthly.
2) Identify the tables that are growing.
3) Are there indexes on these tables? Check the fragmentation of the indexes. Possible create new indexes or revise existing ones.

NOTE: Be careful when adding indexes, it may help your one job, but have a negative impact on the rest of the system.

With the limited information given, I'm giving you some basic areas to investigate. I'll be glad to help you.
Cool | :cool:
QuestionReplace ids with value Pin
Member 1266749416-Mar-18 8:32
MemberMember 1266749416-Mar-18 8:32 
AnswerRe: Replace ids with value Pin
Eddy Vluggen16-Mar-18 8:54
professionalEddy Vluggen16-Mar-18 8:54 
Rant[REPOST] Replace ids with value Pin
Richard Deeming16-Mar-18 11:42
mveRichard Deeming16-Mar-18 11:42 
QuestionReplace Ids With value Pin
Member 1266749416-Mar-18 8:29
MemberMember 1266749416-Mar-18 8:29 
AnswerRe: Replace Ids With value Pin
Victor Nijegorodov16-Mar-18 9:21
MemberVictor Nijegorodov16-Mar-18 9:21 
QuestionDB2 to SQL conversion Pin
Member 1028121715-Mar-18 4:06
MemberMember 1028121715-Mar-18 4:06 
AnswerRe: DB2 to SQL conversion Pin
Victor Nijegorodov15-Mar-18 5:09
MemberVictor Nijegorodov15-Mar-18 5:09 
AnswerRe: DB2 to SQL conversion Pin
Richard Deeming15-Mar-18 6:41
mveRichard Deeming15-Mar-18 6:41 
QuestionBillion rows Pin
jschell10-Mar-18 10:39
Memberjschell10-Mar-18 10:39 
AnswerRe: Billion rows Pin
Jörgen Andersson10-Mar-18 11:42
professionalJörgen Andersson10-Mar-18 11:42 
GeneralRe: Billion rows Pin
jschell14-Mar-18 15:13
Memberjschell14-Mar-18 15:13 
GeneralRe: Billion rows Pin
Mycroft Holmes14-Mar-18 17:29
professionalMycroft Holmes14-Mar-18 17:29 
GeneralRe: Billion rows Pin
jschell17-Mar-18 5:58
Memberjschell17-Mar-18 5:58 
GeneralRe: Billion rows Pin
Mycroft Holmes17-Mar-18 13:18
professionalMycroft Holmes17-Mar-18 13:18 
GeneralRe: Billion rows Pin
jschell24-Mar-18 6:14
Memberjschell24-Mar-18 6:14 
GeneralRe: Billion rows Pin
Mycroft Holmes24-Mar-18 13:08
professionalMycroft Holmes24-Mar-18 13:08 
GeneralRe: Billion rows Pin
jschell31-Mar-18 7:01
Memberjschell31-Mar-18 7:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.