maintainance

I have a SQL server database application,
I just wnated to know that may I maintain the system while user use the
sysetm?
Should I maintain the system while all user off line?
Any information is great appreciated,Hi
It depends on what you are doing, but usually if you can schedule
maintenance when the system is quiet/down it will have less impact. Using
SQL Agent you can schedule your maintainance tasks for quiet times
John
"Souris" <Souris@.discussions.microsoft.com> wrote in message
news:9D26D4FF-1404-4E34-B19D-6DF86A34865D@.microsoft.com...
>I have a SQL server database application,
> I just wnated to know that may I maintain the system while user use the
> sysetm?
> Should I maintain the system while all user off line?
> Any information is great appreciated,
>|||As John said, it depends on the action you want to perform. If you have a
24/7 database you sure have no time slot to do a cold backup ;-). But as
John said, i wouldt places IO-based Activity (rebuilding of indexes) in the
primary processing time. If you have any questions for the details of your
actions you want to perform, do not hesitate to ask.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Souris" <Souris@.discussions.microsoft.com> schrieb im Newsbeitrag
news:9D26D4FF-1404-4E34-B19D-6DF86A34865D@.microsoft.com...
>I have a SQL server database application,
> I just wnated to know that may I maintain the system while user use the
> sysetm?
> Should I maintain the system while all user off line?
> Any information is great appreciated,
>

Maint. plan data optimization on system DBs

Hello,
Does it really make sense to run maint. plan data optimization jobs on
SQL Server 2K system DBs (master,msdb)? If yes, why? Isn't it risky
(e.g. when rebuilding an index fails in the middle of the process)?
Many thanks,
Pablo
No it doesn't - unless you're storing user data in them. You cannot rebuild
the indexes of the critical system tables (sysindexes, syscolumns,
sysobjects) anyway.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"msnews.microsoft.com" <pablo@.this_isnt_my_mail.cc> wrote in message
news:udEsTKpPEHA.308@.TK2MSFTNGP11.phx.gbl...
> Hello,
> Does it really make sense to run maint. plan data optimization jobs on
> SQL Server 2K system DBs (master,msdb)? If yes, why? Isn't it risky
> (e.g. when rebuilding an index fails in the middle of the process)?
> --
> Many thanks,
> Pablo

Maint. plan data optimization on system DBs

Hello,
Does it really make sense to run maint. plan data optimization jobs on
SQL Server 2K system DBs (master,msdb)? If yes, why? Isn't it risky
(e.g. when rebuilding an index fails in the middle of the process)?
--
Many thanks,
PabloNo it doesn't - unless you're storing user data in them. You cannot rebuild
the indexes of the critical system tables (sysindexes, syscolumns,
sysobjects) anyway.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"msnews.microsoft.com" <pablo@.this_isnt_my_mail.cc> wrote in message
news:udEsTKpPEHA.308@.TK2MSFTNGP11.phx.gbl...
> Hello,
> Does it really make sense to run maint. plan data optimization jobs on
> SQL Server 2K system DBs (master,msdb)? If yes, why? Isn't it risky
> (e.g. when rebuilding an index fails in the middle of the process)?
> --
> Many thanks,
> Pablo

Maint. plan data optimization on system DBs

Hello,
Does it really make sense to run maint. plan data optimization jobs on
SQL Server 2K system DBs (master,msdb)? If yes, why? Isn't it risky
(e.g. when rebuilding an index fails in the middle of the process)?
Many thanks,
PabloNo it doesn't - unless you're storing user data in them. You cannot rebuild
the indexes of the critical system tables (sysindexes, syscolumns,
sysobjects) anyway.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"msnews.microsoft.com" <pablo@.this_isnt_my_mail.cc> wrote in message
news:udEsTKpPEHA.308@.TK2MSFTNGP11.phx.gbl...
> Hello,
> Does it really make sense to run maint. plan data optimization jobs on
> SQL Server 2K system DBs (master,msdb)? If yes, why? Isn't it risky
> (e.g. when rebuilding an index fails in the middle of the process)?
> --
> Many thanks,
> Pablo

Main and detail table amount calculations

Hi all,

I have a 2 main tables in my system. One is main table has ticket information location and so on. And detail table which hold all actions on that record with multiple money fields (its around 5 fields). it goes trough some crazy calculations on the detail table and get 5 results for each ticket. And this calculation is done everytime the ticket is looked at.
There is around 10 detail records per 1 main record. and the main table is around 7 mil. records

Now i got 2 options. I can create a trigger that does the calculation and update the main table show the results from there. This is going to affect all updates deletes and inserts.

OR

I can leave as it is so only when they view the ticket it does the calculation. Dont ask me how often they view it i dont have a clue.( if there is any suggestion how to get the count i could try to do it. )
:confused:
Suggestions

(My attitude is going towards the trigger way but 100 percent sure)I can leave as it is so only when they view the ticket it does the calculation.
Yes, you really only want to calculate results from values that are stored in a database and return those results to the client app/report/whatever. Storing calculated values is usually a bad idea. If I were you, I'd go with a third table that details each money field. So, you have the main table, the table with ticket details, then have another table with money details for the ticket details.

eg. Fields:
TicketID, DetailID, MoneyTypeID, Value
-----------
1,1,1,10.00
1,2,1,30.00
1,2,2,1.00
1,2,3,10.50|||you got the question wrong i really dont have too much of changing the data structure is not an big option since the system is already built. I dont have that much options of adding another detailed money table. I need is to decide if i should use triggers and the main table for the calculations or do the calculations on every view Thanks.|||Dont ask me how often they view it i dont have a clue.( if there is any suggestion how to get the count i could try to do it. )
:confused:
How often do they view it? Oh right right - I wasn't to ask :)

If they are accessing this via a sproc then the easy method is log every execution (in fact do this for every sproc) to a table and then query your table.

If not then you could run a profiler trace (http://www.developer.com/db/article.php/3482216) save the results to a table or to a trace file (trace file is more efficient and you can dump the results in a table once the trace is over) and query the table. You would be querying the TextData column for the SQL:BatchCompleted event.

HTH|||sadly on the server there is a wierd problem. Trace is not working. and lets say for how often they look up a ticket is, insanely often. probably the data is viewed alot more often then it is updated. I hope that make sense to help awnser the main part of the question. Thanks

mail error

Iam unable to send out emails since we changed the system
acount name...
when I test the email name I get the following message
'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
session is not running; check the mail profile and or
SQLServerAgent service startup acount in SQLServerAgent
properties dialogue box'
the mail configeration test works ok and restarted
SQLServerAgent.. any ideasgrumy,
When you say you changed the "system account name", what exactly are you
referring to? The MSSQLServer service account name?
I am also not clear on whether your SQLServerAgent service is running or
not. The error message states that it is not running, but you are saying
that SQLServerAgent was restarted successfully. Could you clarify your
questions?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"grumy" <anonymous@.discussions.microsoft.com> wrote in message
news:2f5e01c4289b$d6d1eba0$a301280a@.phx.gbl...
> Iam unable to send out emails since we changed the system
> acount name...
> when I test the email name I get the following message
> 'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
> session is not running; check the mail profile and or
> SQLServerAgent service startup acount in SQLServerAgent
> properties dialogue box'
> the mail configeration test works ok and restarted
> SQLServerAgent.. any ideas

Machine account access

Hi everyone,
I'm trying to access SQL Server from an application that is a service
running under the "Local System" account in a computer which is not the same
as the one running SQL Server. The service must run under this account, and
still should have access to an SQL Server database.
I've given permissions to the computer account in SQL Server, as both
computers are in Active Directory, but the service still does not connect
(due to permissions).
Is it possible to have this scenary running? Any idea on how to make it work
?
Thanks in advance,
Lleonard.Local system does not have access to network resources.
-Sue
On Wed, 27 Jul 2005 09:17:06 -0700, "lleonard"
<lleonard@.discussions.microsoft.com> wrote:

>Hi everyone,
>I'm trying to access SQL Server from an application that is a service
>running under the "Local System" account in a computer which is not the sam
e
>as the one running SQL Server. The service must run under this account, and
>still should have access to an SQL Server database.
>I've given permissions to the computer account in SQL Server, as both
>computers are in Active Directory, but the service still does not connect
>(due to permissions).
>Is it possible to have this scenary running? Any idea on how to make it wor
k?
>Thanks in advance,
>Lleonard.

LowLlevel Error

We see the below error from time to time as a popup message on the
desktop. The same error appears in the system event log as Source:
Application Popup Event ID: 26. We haven't been able to identify any
specific event which causes it to happen.
Start Error ----
Application popup: Microsoft Visual C++ Runtime Library : Buffer overrun
detected!
Program: C:\PROGRA~1\MICROS~1\MSSQL\binn\sqlservr.exe
A buffer overrun has been detected which has corrupted the program's
internal state. The program cannot safely continue execution and must
now be terminated.
End Error ----
After the message appears, the running sqlservr.exe process is frozen
and clients can no longer access the database. Ending task from the
task manager doesn't even work and we have to reboot the server to get a
functioning SQL server service.
Anyone have ideas? I couldn't find much help with google. We are
running SQL Server 2000 with SP3.
~Jason
--No one has seen this error before? :(
~Jason
--