Viewing 15 posts - 3,676 through 3,690 (of 19,560 total)
You could use one of the templates. Here is a list and description of those templates.
http://technet.microsoft.com/en-us/library/ms190176.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 15, 2014 at 10:12 am
Sounds like the accounts were expiring.
You can checked for disabled, locked, or expired accounts using this script. You should probably monitor for this kind of thing.
SELECT sl.name,sl.is_disabled,sl.is_expiration_checked,sl.is_policy_checked,sl.modify_date
,LOGINPROPERTY(sl.name,'IsExpired') AS IsExpired,LOGINPROPERTY(sl.name,'DaysUntilExpiration')...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 15, 2014 at 10:05 am
Here is something that will work. One significant difference is that when converting time to decimal, you usually use .25 instead of 15 increments. Based on that, here...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 15, 2014 at 12:31 am
Here is an alternate script that provides more complete information.
http://jasonbrimhall.info/2011/11/21/table-space-cs-part-deux/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 14, 2014 at 6:50 pm
Here is an alternative that gives a bit more info.
http://jasonbrimhall.info/2011/11/21/table-space-cs-part-deux/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 14, 2014 at 6:47 pm
Here is an alternative for getting more info about table size, index size and overall size.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 14, 2014 at 6:45 pm
Consider like read only access to dmv/system information and schema info but not the direct ability to view the data
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 14, 2014 at 6:31 pm
For those interested, lowell (an ssc regular) put together quite a handy Calendar Table that can be viewed here
http://www.stormrage.com/SQLStuff/TallyCalendar_Complete_With_DST.txt
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 14, 2014 at 4:00 pm
Like George said, shrinking as a 1 off is not such a bad thing.
High vlf will adversely affect restores and operations that touch the transaction log.
While instant file initialization will...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 14, 2014 at 1:57 pm
Here is an article that discusses it (running totals)
http://blog.waynesheffield.com/wayne/archive/2011/08/running-totals-in-denali-ctp3/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 14, 2014 at 1:52 pm
On a nightly basis you can run sp_cycle_errorlog (http://technet.microsoft.com/en-us/library/ms182512.aspx)
And then change the log retention to 30 days or so (or more depending on your needs).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 14, 2014 at 1:45 pm
Are you limited to SQL 2008 for this? Or do you have SQL 2012 available?
2012 has a feature that allows this kind of "quirky update" to be done using...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 14, 2014 at 1:40 pm
Here is another alternative to get the info for all databases.
CREATE TABLE #FileProp (dbid INT,FILE_ID INT, SpaceUsed DECIMAL(14,2));
GO
EXECUTE sp_MSforeachdb 'USE ?; Insert Into #FileProp (dbid,FILE_ID,SpaceUsed)
SELECT database_id,file_id,FILEPROPERTY(name,''SpaceUsed'') from sys.master_files...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 14, 2014 at 12:58 pm
Sid Childers (2/14/2014)
What do you (and others) think is a minimum amount of RAM to make hosting a VM or two viable?
IMHO, at least 8gb RAM. 16gb is optimal,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 14, 2014 at 12:46 pm
TheGreenShepherd (2/14/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 14, 2014 at 12:41 pm
Viewing 15 posts - 3,676 through 3,690 (of 19,560 total)