[MS SQL Server] how to create the alerts for services |
- how to create the alerts for services
- Tempdb grows suddenly.
- create user script
- SQL server startup parameters
| how to create the alerts for services Posted: 29 Aug 2013 03:14 AM PDT Hi all.here in my environment we are not using any monitoring tools for alerts.we are planning to create the alerts. if the services are down we need a alert message. how can i configure the alerts without monitoring tool. |
| Posted: 28 Aug 2013 08:50 PM PDT HiI know that TempDB grows if it needs and if you restart the sql server the TempDB resets to it's configured size.On a sql server we have i have never had any problem with TempDB.The size has always been about 2 GB.I have run many big querys against it and it have never grown.Every week a rebuild index is being run on the databas that is about 40GB.But suddenly , the size jump up to 24 GB on the TempDB.I restart the server and everything is normal.But then over a night the size jump up to 42 GB.And during that time the only thing that has happen is the same thing thathas happend every night.If i run:SELECT SUM(unallocated_extent_page_count) AS [free pages], (SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB]FROM sys.dm_db_file_space_usage;It says that about 40 GB is free space in TempDB.I am very confused.What should i do ? |
| Posted: 28 Aug 2013 07:42 AM PDT I'd like to have a script that contains all the creation of users and statements to add those users to different roles. I have to restored this particular database and on every restore I loose the security assignment on my users. I could use the user interface to reset those users but it would be much easier to use the script since I have to restore every week.I have the following script, but I'd like to assign the dbo as the default schema for each use so I don't end up creating user schemas.CREATE LOGIN [DOMAIN\user1] FROM WINDOWS;GOUSE [Database1]GOCREATE USER "DOMAIN\user1" FOR LOGIN "DOMIAN\user1"EXEC sp_addrolemember N'db_datareader', N'DOMAIN\user1"EXEC sp_addrolemember N'db_executor', N'DOMAIN\user1"The script above works great but when I go to my security for the user on the database I see that a schema "DOMIAN\user1" has been created and assigned to the database user. How can I assign the schema "dbo" to the newly created database user?Thank you. |
| Posted: 28 Aug 2013 06:15 AM PDT Hi,Can anyone provide me the stored proc or script to get all start parameters for an instance.Thanks in advance |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment